Resolving Archive Gaps in ASM Disk in Oracle Dataguard

Resolving Archive Gaps in ASM Disk in Oracle Dataguard

We have archive on Production Server but we need to apply manually on DR server.
Archive is present in ASM disk. So We have two option to resolve these:

1. Manually apply the archive log by moving archive from prodution ASM disk to DR AMS disk.
2. Take archive backup from prod and apply to standby.

Option 1
Manually apply the archive log by moving archive from prodution ASM disk to DR AMS disk

1. Check the GAP between Primary and Standby enviornment.

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

OR

SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#;

2. Check the location of archive missing

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

3. Use RMAN Copy for get Archive log from ASM Diskgroup and copy to local disk.

copy archivelog '+DGROUP2/PROD/datafile/ARC00001113_0732997804.001' to '/u01/app/oracle/ARC00001113_0732997804.001';

4. SCP or FTP the archive logs from production to standby.

scp /backup/ARC00001113_0732997804.001 :/backupstandby/

5. Copy the archive file to Standby ASM Disk

rman target /
RMAN>copy archivelog '/u01/app/oracle/ARC00001113_0732997804.001' to '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';

6. Register manually by mentioning the copied file location.

SQL>alter database register logfile '+DGROUP2/STDBY/datafile/ARC00001113_0732997804.001';

7. Start the Recovery process on Standby Database.

-- For restart the recover
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

--IF you have standby then start recover as:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Option 2: Take archive backup from prod and apply to standby.
Follow the following link: RMAN ARCHIVE GAP

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.