Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archive Gap - Physical Standby Database

892831Nov 1 2011 — edited Nov 4 2011
Hello 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)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2011
Added on Nov 1 2011
7 comments
12,894 views