Normally in DR setup, the archives from primary shipped to standby and applied there. Suppose some of the archives hasn’t been shipped to secondary .But due to intermittence error or human error, the archives has been deleted from primary. So without those archives, standby can’t be in sync with primary.

 

In oracle 12c  , We can use the rolling forward method to fix it . See Full article

Here i have created a setup where archive is missing before it is being applied in the physical standby.

As we have removed the new archives from primary, the standby database can’t proceed with the
recovery without these logs.

Solution:

 

Get scn of both primary and standby:

2791087- Take a note of this scn, as we need to recover from this scn

 

5. [Primary] take an incremental backup in primary from the scn number which we got in step 2 .

6. [Primary] Create a new standby controlfile in primary

7. Copy the rman backup file and new standby controlfile to standby database.

In standby the files were copied to /home/oracle/raj/.

8. [Standby] Start standby in startup nomount

9. [Standby] Find the location of controlfile in standby.

10. [Standby] Replace the controlfile in standby side with the one you just created in primary.

cp /home/oracle/raj/control02.ctl /u04/TEST/oradata/control02.ctl

11. [Standby] Mount standby database

12. [Standby] Catloging rman files.

RMAN does not know about these files yet; so you must let it know – by a process called cataloging.

Catalog these

13. [Standby] Recover the database

<< If above errors are coming, then cancel the recovery again >>>

This error are expected errors.This happens because we have come to the last of the archived logs. The expected archived log with sequence# 8008 has not been generated yet.

 

start MRP

Now the standby is completely in sync with primary and recovery is running fine. Lets check that.

Now check the archive status in both the databases.

3. [Standby] Check the processes running on standby.

4. [Primary] switch logfiles to confirm whether new archives are getting applied or not