How DataGuard Gaps Resolve ?

If archivelogs Gap is more,we have to take SCN Incremental Backup

Syncing DataGuard using SCN Based Incremental Backup :

1. Check the  Bothside ( primay and Standby Database ) Current SCN number,applied Archivelogs and Archivelog Gaps

   By using this views v$archive_log ( to check Applied archivelogs )
                              v$archivelog_gap  (to check archivelog gaps )
                              v$database (SCN Information)
   2. take the SCN incremental Backup
    
 Rman>backup incremental from SCN '143143' database format                                                  '/u01/rman_inc_local/forstandby_%' tag 'forstandbylocal';

3. Tansfer that backup sets created on the primary system to  Standby system.

    $ scp backupfiles username@target server name:'/u01/h0me/standby'

4. connect to standby database as the rman target and catalog all incremental backup piece.

        Rman>catalog start with '/u01/rman_inc_local'

5. recover the standby database with no redo option.

    rman >recover database noredo;


6. in Rman, connect to the primary database and create a standby controlfile backup

   Rman>backup current controlfile for standby format '/u01/rman/standbycontrol.ctl';


7. stop the MRP process

8. Shutdown the standby database.

9. start the databae no mount

10. Restore the standby controlfile

Rman>restore standby controlfile from '/u01/rman/standbycontrol.ctl';


11. Mount the Standby Database

12.start the MRP process

13. Check the Current SCN number,applied Archivelogs and Archivelog Gaps

   By using this views v$archive_log,v$archivelog_gap,v$database(SCN Information)


14. Check DG configuration status using broker

OCMCWPAL>dgmgrl
DGMGRL> connect sys/pwd@tns
DGMGRL>show configuration verbose;

It wil show Protection mode: like max_availibility

If archivelogs Gap is less,then we have to Register the logs 

1. Check the  Bothside ( primay and Standby Database ) Current SCN number,applied Archivelogs and Archivelog Gaps

   By using this views v$archive_log ( to check Applied archivelogs )

                              v$archivelog_gap  (to check archivelog gaps )

                              v$database (SCN Information)

2. Stop the MRP process
     
3. Register the log files
            SQL>alter database register logfile '/u01/home/arch77.dbf';

4. Start the MRP process