This discussion is archived
3 Replies Latest reply: Sep 20, 2012 7:36 AM by 954935 RSS

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

954935 Newbie
Currently Being Moderated
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

Legend

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