10 Replies Latest reply: Sep 5, 2013 6:31 AM by Pradeepcmst RSS

    how to apply missing archive logs to standby db

    John-MK

      Hello,

       

      I had to shutdown physical standby db for 4 hours for shifting to another location.

       

      After restart It seems there are 4 missing archive logs and I think because of them other archive logs are not being applied.

      SYS@standbydb AS SYSDBA> select * from V$ARCHIVE_GAP;   -- on Primary there are no rows selected.

       

         THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#

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

           1       36226      36230

      Standby: SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG where applied='NO';

      1    36231 NO

      - - -

      1    36247 NO

      36226 is the last one with the APPLIED: YES

       

      I have following errors in the GRID CONTROL DATA GUARD STATUS option

       

      ORA-16783: cannot resolve gap for database  standby_db

      ORA-16629: database reports a different protection level from the protection mode

       

      Please help to resolve this archive gap...

       

      Thanks a lot

       

      Best Regards