Archive Gap - Physical Standby Database
892831Nov 1 2011 — edited Nov 4 2011Hello All,
I'm seeing some archive log gap in physical standby database.
SQL> SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;
THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 7353 7355
But when I query the above gaps in primary I'm not able to see any thing
SQL> SELECT NAME FROM V$ARCHIVED_LOG WHERE THREAD#=1 AND DEST_ID=1 AND SEQUENCE# BETWEEN 7353 AND 7355;
NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Can any one please help, How to get those files..since i need to copy those missing files from primary to standby and recover the standby database to sync up with primary.
Oracle 11gR2 in RHEL5 ( Primary : 2 node RAC , Stdby : Standalone - Physical Standby)