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 ;
}

Related posts

How to deal with ORA-00020: maximum number of processes (%s) exceeded

How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database 

Công cụ tự động khai báo datafile – Oracle