Resolving Archive Gaps with RMAN Command in Oracle Dataguard

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

1 thought on “Resolving Archive Gaps with RMAN Command in Oracle Dataguard

  1. Pingback: Resolving Archive Gaps in ASM Disk in Oracle Dataguard | Smart way of Technology

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.