1 Reply Latest reply: Oct 8, 2013 5:57 AM by Pleiadian RSS

    Dataguard GAP showing in Minus(-)

    978865

      hi there,

      we have just migrated from oracle 9.2.0.3.0 to 11.2.3.0 on IBM - AIX

       

      DR also have been migrated from 9.2.0.3.0 to 11.2.3.0.

       

       

      previously we used to check for the DR GAP count with the help of below query on 9i.

       

      {code}

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

      FROM

      (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,

      (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

      WHERE

      ARCH.THREAD# = APPL.THREAD#

      ORDER BY 1;

       

      {code}

       

       

      {code}

      Thread Last Sequence Received Last Sequence Applied Difference

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

           1             403280            404811  -1531

      {code}

       

       

      so why its showing the difference in Minus.

      MRP process is down when there was  a GAP of 7000 logs. and some 1000 logs have been copied manually. and below command have been fired on DR site

       

      {code}

      alter database recover standby database

      {code}

      so friends what is the issue here. need help.