Archive gap on oracle db

1) Query v$archive_gap;

2) Note difference between low sequence and high sequence.

3) Copy the files to standby_archive_dest.

4) Do alter database register logfile for all the copied archive logs.

5) Managed recovery.

6) On the standby database, query the V$ARCHIVED_LOG view to verify the archived redo log was applied.

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;





Doing the 4th step updates the standby control file. The MRP process is checking the control
file when the managed recovery is activated and applies the new archive logs in the stdby control
file. In normal log-shipping, the update to the control file is done by the RFS.