How to move missing archive log files from Primary ASM to Physical Standby ASM when there is a gap?(Doc ID 1499512.1)In this DocumentGoalSolutionReferences

APPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.***Checked for relevance on 5-Aug-2014***GOAL

When there is a gap between the primary and the physical standby databases, and the archive log files are on ASM on both the primary and the standbysites,how to move the missing archive log files from the primary site ASM diskgroup to the standby site ASM diskgroup?

SOLUTIONPlease use the rman scripts below to backup missing archive log files from the primary site and restore to the standby site.RMAN> run {allocate channel c1 type disk;backup archivelog from sequence x1 until sequence x2 thread 1 format '/oraback/arch/arch_%U';}Then use the same script to backup for thread 2. For example,RMAN> run {allocate channel c1 type disk;backup archivelog from sequence x1 until sequence x2 thread 2 format '/oraback/arch/arch_%U';}Note: Please make sure the path /oraback/arch/ exists on the primary site or use any other existing path.Copy the backup pieces from the primary site to the standby site. Then restore them byRMAN> run{catalog start with '/oraback/arch/';allocate channel c1 type disk ;restore archivelog from sequence x1 until sequence x2 thread 1;}Use the same script to restore for thread 2 archive log files.RMAN> run{catalog start with '/oraback/arch/';allocate channel c1 type disk ;restore archivelog from sequence x1 until sequence x2 thread 2;}Note: Please make sure the path /oraback/arch/ exists on the standby site.REFERENCES

NOTE:740675.1 - Online Redo Logs on Physical StandbyDidn't find what you are looking for?

Document 1499512.1 https://support.oracle.com/epmos/faces/DocumentDispl...

1 dari 2 10/11/2015 8:54 AM

Document 1499512.1 https://support.oracle.com/epmos/faces/DocumentDispl...

2 dari 2 10/11/2015 8:54 AM