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