Friday, October 24, 2008

Resync Standby Using Automatic Gap Sequence fix

Shutdown standby and startup mount.
Do :

SELECT * FROM V$ARCHIVE_GAP;

THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
---------- ------------- --------------
1 4115 4123

On primary if archives are not in the default path then use rman to restore them:
restore archivelog from sequence 4115 until sequence 4123;

Then on standby
alter database recover managed standby database disconnect;
To start the gap sequence fix and to apply all archives.

1 comment: