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

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