8 Replies Latest reply on Feb 22, 2013 3:39 AM by 973679

    v$archived noy sync in Dataguard

    973679
      Hi,

      My question is about a doubt that I had y my Dataguard.

      Few days ago I did a scn incremental restore in order to sync Primary and Standby instances, the problem is v$archived_log is not updated. Let me show you

      Primary:

      select max(sequence#), to_char(next_time,'DD-MON-YY:HH24:MI:SS'), applied from v$archived_log group by to_char(next_time,'DD-MON-YY:HH24:MI:SS'), applied order by 1 desc
      .
      .
      .
      .
      923426 17-FEB-13:07:16:38 NO

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


      MAX(SEQUENCE#)
      --------------
      915252



      Standby:


      select max(sequence#), to_char(next_time,'DD-MON-YY:HH24:MI:SS'), applied from v$archived_log group by to_char(next_time,'DD-MON-YY:HH24:MI:SS'), applied order by 1 desc
      .
      .
      .
      923426 17-FEB-13:07:16:38 YES


      When I do automatic recover the gap is:


      Fetching gap sequence in thread 1, gap sequence 923427-923526



      My question is why I have different values on that queries?

      Thanks a lot!

      Edited by: 970676 on Feb 21, 2013 4:31 PM