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

    Standby Gaps after changing sys password

    yxes2013

      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