Gaps Resolving in DataGuard Physical Standby Using RMAN Incremental Backup. SQL>alter system set log_archive_dest_state_2=’DEFER’ scope=MEMORY; 2) record last sequence from Primary and Standby SQL> archive log list; or use sql. Perform Rman Incremental backup from Primary database to backup the gap starting from Standby SCN.

Which causes the Standby is very far behind the Primary database, then an RMAN INCREMENTAL BACKUP can be used to roll the Standby database forward faster than redo log apply. When the archived logs are missing on the Standby database, simply we can ship missing logs from the Primary to Standby database; (If missing logs are very less count e.g. We need to register all Shipped logs in the Standby database so that Gap can be resolved. In this article I will demonstrate how to resolve archive log gaps using following methods.