12 Replies Latest reply: Sep 19, 2013 8:20 PM by yxes2013 RSS

    What happened to my Standby? :(

    yxes2013

      Hi all,

       

      11.2.0.1

      Aix 6.1

       

      I checked my standby and I noticed that there lots of gaps. So from the advise here I decided to make incremental  backup to sync the standby.

       

      @PRIMARY DB:

       

      SQL> select status,instance_name,database_role from v$database,v$instance;

       

       

      STATUS       INSTANCE_NAME    DATABASE_ROLE

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

      OPEN         PROD            PRIMARY

       

       

      SQL> select thread#,max(sequence#) from v$archived_log group by thread#;

       

       

         THREAD# MAX(SEQUENCE#)

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

               1            593

       

       

       

      @STANDBY DB:

      =============

      SQL> select status,instance_name,database_role from v$database,v$instance;

       

       

      STATUS       INSTANCE_NAME    DATABASE_ROLE

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

      MOUNTED      PRODDR          PHYSICAL STANDBY

       

       

       

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

       

       

         THREAD# MAX(SEQUENCE#)

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

               1           5057

       

       

      ========

       

      WHY is that the sequence in DR is greater than the sequence in PRIMARY?

       

      Please help.....

       

       

      Thanks,

      zxy