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

This entry was posted in Oracle on by .

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply

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