How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [I
来源:互联网 发布:福州临床数据分析员 编辑:程序博客网 时间:2024/06/05 22:52
How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [ID 1271114.1]
修改时间 04-JAN-2012 类型 HOWTO 状态 MODERATED
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Information in this document applies to any platform.
On standby,
2. On primary Check the location where the missing logfiles exist.
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=<n> AND DEST_ID=<n> AND SEQUENCE# BETWEEN <LOW_SEQUENCE#> AND <HIGH_SEQUENCE#>;
For example,
3. Use RMAN to copy to someother local filesystem.
Do the same for all the logs.
4. SCP to standby.
scp /u01/app/oracle/ARC00001113_0732997804.001 drs1.idc.oracle.com:/u04/standby/
5. Register manually by mentioning the copied file location.
On standby,
修改时间 04-JAN-2012 类型 HOWTO 状态 MODERATED
In this Document
Goal
Solution
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.1 - Release: 10.2 to 11.2Information in this document applies to any platform.
Goal
The note describes how to find a GAP and resolve it in case of ASM on both primary and standby or ASM on either primary or standby.Solution
1. Check for the GAP,On standby,
SQL>SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
2. On primary Check the location where the missing logfiles exist.
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=<n> AND DEST_ID=<n> AND SEQUENCE# BETWEEN <LOW_SEQUENCE#> AND <HIGH_SEQUENCE#>;
For example,
SQL> SELECT * FROM V$ARCHIVE_GAP;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
----------- ------------- --------------
1 1113 1115
SQL> SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 1113 AND 1115;
NAME
--------------------------------------------------------------------------------
+DGROUP2/PROD/datafile/ARC00001113_0732997804.001
+DGROUP2/PROD/datafile/ARC00001114_0732997804.001
+DGROUP2/PROD/datafile/ARC00001115_0732997804.001
3. Use RMAN to copy to someother local filesystem.
RMAN>copy archivelog '+DGROUP2/PROD/datafile/ARC00001113_0732997804.001' to '/u01/app/oracle/ARC00001113_0732997804.001';
Do the same for all the logs.
4. SCP to standby.
scp /u01/app/oracle/ARC00001113_0732997804.001 drs1.idc.oracle.com:/u04/standby/
5. Register manually by mentioning the copied file location.
On standby,
SQL>alter database register logfile '/u01/app/oracle/ARC00001113_0732997804.001';
NOTE : Alternatively we can copy this archive log to standby ASM location and then do a register.
On standby,
$rman target /
RMAN>copy archivelog '/u01/app/oracle/ARC00001113_0732997804.001' to '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';
Now register,
SQL>alter database register logfile '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';
- How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [I
- How to Copy Archivelog Files From ASM to Filesystem and vice versa
- How to copy a datafile from ASM to a file system not using RMAN
- How to create Oracle 11g R2 database manually in ASM?
- How to copy a datafile from ASM to a file system not using RMAN (Doc ID 428893.1)
- How to inline ASM in C (gcc)
- How to Copy asm files between remote ASM instances using ASMCMD command
- How to Include ASM File and to Highlight Display in Source Insight
- How to Increase CSS Misscount in single instance ASM installations
- How to rename ASM instances in RAC or clustered environment
- How to perform Rolling Upgrade-Downgrade in 11g ASM
- How to perform Rolling Upgrade-Downgrade in 11g ASM
- How To Create manually an ASM Instance From Scratch
- How to config (no)archivelog mode and manage archive log files by RMAN (Updated to 10G)
- How To Setup Partitioned Linux Block Devices Using UDEV (Non-ASMLIB) And Assign Them To ASM
- How To Drop and Recreate ASM Diskgroup
- How do I write to files using cheerio and request in node?
- How To Delete Archive Log Files Out Of +Asm
- 使用XFire+Spring构建Web Service(一)——helloWorld篇
- 设计模式(六)——组合起来:用模式思考
- linux内核宏定义
- SQL优化思路
- BOOL , float, 指针变量与“零值”比较的if 语句
- How to Manually Determining and Resolving Archive Gaps in ASM (Copy archivelog in ASM using RMAN) [I
- .class的程序化操作(java反射机制)
- mysql 添加用户和创建数据库
- tromino谜题C++实现
- Yii - 注册Javascript到页面中
- arguments.callee 等js高手采用的属性
- .NET简谈设计模式之(抽象工厂模式)
- EditText对行光标默认第一行问题
- Jquery插件的使用--AutoComplete