本文主要是介绍How to Manually Determining and Resolving Archive Gaps in ASM，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
(Copy archivelog in ASM using RMAN) [ID 1271114.1]
Information in this document applies to any platform.
On standby,
Ref : How To Check Whether Physical Standby is in Sync with the Primary? (Doc ID 861595.1)
2. On primary Check the location where the missing logfiles exist.
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#= AND DEST_ID= AND SEQUENCE# BETWEEN AND ;
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,
| 修改时间 17-FEB-2011 类型 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;
Ref : How To Check Whether Physical Standby is in Sync with the Primary? (Doc ID 861595.1)
2. On primary Check the location where the missing logfiles exist.
SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#= AND DEST_ID= AND SEQUENCE# BETWEEN AND ;
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
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';
$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';
产品
| ||
相关的
返回页首
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/38267/viewspace-707723/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/38267/viewspace-707723/
这篇关于How to Manually Determining and Resolving Archive Gaps in ASM的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
