This discussion is archived
10 Replies Latest reply: Sep 5, 2013 4:31 AM by Pradeepcmst RSS

how to apply missing archive logs to standby db

John-MK Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points