Oracle Standby Database

[Former Member]

Dear All,

We have implemented DR Solution using oracle dataguard.

Our Oracle database version is Oracle 12c.

Due to network issue there are some gap in archive logs. So we have manullly copied archive log to DR Server and apply.

All the archives were applied but automatic managed recovery mode is started.

But when run the following sql stmt to check the pending logs to be applied system shows old arhive log which is not applied.

SQL> select thread#,sequence#,applied,registrar from v$archived_log where applied <> 'YES';

   THREAD#  SEQUENCE# APPLIED   REGISTR

---------- ---------- --------- -------

         1       2149 NO        RFS

         1       2430 IN-MEMORY RFS

System shows 2149 sequence no. as "Deleted" status.

How to resolve ?

Thanks and Regards,

Nirav

[JamesZ]

Hi Nirav,

Can you attach both alert log from primary and standby?

Also are you using data broker？

Best regards,
James