6 Replies Latest reply: Feb 6, 2014 11:18 PM by Renu-Oracle RSS

    Error ORA-16724: cannot resolve gap for one or more standby databases

    datsun80

      I came in to work today with the following error displayed:

      Feb 5, 2014 1:27:19 AM Error ORA-16778: redo transport error for one or more databases.


      It looks like that error went away but now I have the following error:

      Feb 5, 2014 11:52:40 AM Error ORA-16724: cannot resolve gap for one or more standby databases

       

      I did some research on the forums and I think I need to backup and restore but I am not sure.

       

      Here are some queries I saw other people asking for in the forums:

       

      PRIMARY:

      select max(sequence#)  from v$archived_log; ---- 24589

      select current_scn from v$database; ----- 871568619

       

      SECONDARY:

      select max(sequence#)  from v$archived_log; ----- 24589

      select max(sequence#)  from v$archived_log where applied = 'YES'; ----- 24562

      select current_scn from v$database; ----- 870987797

      select * from v$archive_gap;

      Thread# Low_Sequence# High_Sequence#

      1    24563    24563

       

      It looks like everything is working yet the error is still showing up in OEM on the primary.