SQL> SELECT TYPE, HIGH_SCN, STATUS FROM V$LOGSTDBY;

TYPE HIGH_SCN STATUS
------------ ---------- --------------------------------------------------
COORDINATOR ORA-16112: log mining and apply stopping

SQL> SELECT NAME, VALUE FROM V$LOGSTDBY_STATS WHERE NAME LIKE 'coordinator%' or NAME LIKE 'transactions%';

NAME VALUE
----------------------------------- -----------------------------------
coordinator state INITIALIZING
transactions ready 0
transactions applied 0
coordinator uptime 2546

SQL> SELECT EVENT_TIME, STATUS, EVENT FROM DBA_LOGSTDBY_EVENTS ORDER BY EVENT_TIME, COMMIT_SCN;

EVENT_TIME STATUS
------------------ ------------------------------------------------------------
EVENT
--------------------------------------------------------------------------------
20-MAR-05 19:46:58 ORA-16111: log mining and apply setting up

SQL> SELECT FILE_NAME, SEQUENCE#, FIRST_CHANGE#, NEXT_CHANGE#, TIMESTAMP, DICT_BEGIN, DICT_END, THREAD# FROM DBA_LOGSTDBY_LOG ORDER BY SEQUENCE#;

FILE_NAME
--------------------------------------------------------------------------------
SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# TIMESTAMP DIC DIC THREAD#
---------- ------------- ------------ ------------------ --- --- ----------
/devfin1/standbyArc/arch_1_30075.arc
30075 3180452738 3180453321 20-MAR-05 19:42:48 NO NO 1

/devfin1/standbyArc/arch_1_30076.arc
30076 3180453321 3180453354 20-MAR-05 19:43:06 NO NO 1

/devfin1/standbyArc/arch_1_30077.arc
30077 3180453354 3180460541 20-MAR-05 21:23:38 NO NO 1
......too many logfiles...OMITTED.......
..............................OMMITED...
/devfin1/standbyArc/arch_1_30218.arc
30218 3181709641 3181720027 22-MAR-05 13:56:47 NO NO 1

/devfin1/standbyArc/arch_1_30219.arc
30219 3181720027 3181726092 22-MAR-05 14:01:57 NO NO 1


145 rows selected.

SQL> SELECT L.SEQUENCE#, L.FIRST_TIME, (CASE WHEN L.NEXT_CHANGE# < P.READ_SCN THEN 'YES' WHEN L.FIRST_CHANGE# < P.APPLIED_SCN THEN 'CURRENT' ELSE 'NO' END) APPLIED FROM DBA_LOGSTDBY_LOG L, DBA_LOGSTDBY_PROGRESS P ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIME APPLIED
---------- ------------------ -------
30075 20-MAR-05 18:55:06 NO
30076 20-MAR-05 18:58:06 NO
30077 20-MAR-05 18:58:10 NO
.......from 30078 till 30217...OMITED...HERE...
30218 22-MAR-05 13:46:58 NO
30219 22-MAR-05 13:56:41 NO
145 rows selected.