Re: Dataguard logs

Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Dataguard-logs-tp1478p8651.html

Primary:
SQL> SELECT THREAD#, MAX(SEQUENCE#)
FROM V$LOG_HISTORY
WHERE RESETLOGS_CHANGE# =
(SELECT RESETLOGS_CHANGE#
FROM V$DATABASE_INCARNATION
WHERE STATUS = 'CURRENT')
GROUP BY THREAD#;  2    3    4    5    6    7

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1          37629
         2          42813

target:
SQL> select al.thrd "Thread", almax "Last Seq Received", lhmax "Last Seq Applied"
from (select thread# thrd, max(sequence#) almax
      from v$archived_log
      where resetlogs_change#=(select resetlogs_change# from v$database)
      group by thread#) al,
     (select thread# thrd, max(sequence#) lhmax
      from v$log_history
      where first_time=(select max(first_time) from v$log_history)
      group by thread#) lh
where al.thrd = lh.thrd  2    3    4    5    6    7    8    9   10
 11  ;

    Thread Last Seq Received Last Seq Applied
---------- ----------------- ----------------
         2             42813            42774

I noticed the mrp0 is not running:
SQL> select process,status,sequence# from v$managed_standby;

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
ARCH      CLOSING           42813
ARCH      CONNECTED             0
ARCH      CLOSING           42811
ARCH      CLOSING           42812
RFS       RECEIVING         37603
RFS       RECEIVING         37604
RFS       RECEIVING         42791
RFS       RECEIVING         42814
RFS       RECEIVING         42792
RFS       RECEIVING         42790
RFS       RECEIVING         37590

PROCESS   STATUS        SEQUENCE#
--------- ------------ ----------
RFS       RECEIVING         37631