This discussion is archived
1 2 3 4 Previous Next 57 Replies Latest reply: Oct 17, 2013 3:43 AM by BluShadow RSS

Standby Gaps after changing sys password

yxes2013 Newbie
Currently Being Moderated

Hi all,

 

11.2.0.1

aix6.1

 

I changed our sys password at primary db and copy the "orapwdprod" from source dbs  to "orapwdproddr"  at standby dbs.

But I noticed that the log is not sync.


  1  SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"

  2  FROM

  3  (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,

  4  (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL

  5* WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1

SQL> /

 

 

    Thread Last Sequence Received Last Sequence Applied Difference

---------- ---------------------- --------------------- ----------

         1                   2635                  2594         41


 

Where can I check the error why is it not applying acrhive logs

 

Thanks,

zxy

1 2 3 4 Previous Next

Legend

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