3 Replies Latest reply: Sep 20, 2012 9:36 AM by 954935 RSS

    standby db can't find the sequence number of the last applied archivelog

    954935
      Hello,

      the phsical standby is corrupted and lag behind the primary db, so we do a repaire
      (http://shivanandarao.wordpress.com/2012/03/26/roll-forward-physical-standby-database-using-rman-incremental-backup/) and restart MRP.

      the go to standby db, find:

      sql> select process,status,sequence# from v$managed_standby;


      PROCESS STATUS SEQUENCE#
      --------- ------------ ----------
      ARCH CLOSING 33869
      RFS IDLE 33871
      RFS IDLE 0
      MRP0 WAIT_FOR_GAP 33384

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

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



      so why I can't see the the sequence number of the last applied archivelog??

      thank you

      Edited by: 951932 on Sep 20, 2012 7:27 AM