Resolving Archive Gaps with RMAN Command in Oracle Dataguard

In this case you must have archive present in the Server or backup location. So that you applied on Standby Server.

1. Check the GAP between Primary and Standby enviornment.

SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;


2. Check the location of archive missing

SELECT NAME FROM V$ARCHIVED_LOG WHERE SEQUENCE# BETWEEN AND ;

3. Backup the Archive log from Production Server:

RMAN> run {
allocate channel c1 type disk;
backup archivelog from sequence until sequence thread 1 format '/oraback/arch/arch_%U';
}


4. Copy(SCP or FTP) the Backup from primary site to DR site.

scp /backup/ARCH_0732997804.bak :/backupstandby/


5. Restore on Standby Database:

RMAN> run
{
catalog start with '/oraback/arch/';
allocate channel c1 type disk ;
restore archivelog from sequence until sequence ;
}