GV$RECOVERY_STATUS

select
fx.inst_id,              -- INST_ID NUMBER
to_date                  -- RECOVERY_CHECKPOINT DATE
  (mx.ckptim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
mx.thr,                  -- THREAD NUMBER
mx.seq,                  -- SEQUENCE_NEEDED NUMBER
mx.los,                  -- SCN_NEEDED VARCHAR2(16)
to_date                  -- TIME_NEEDED DATE
  (mx.tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
nvl (mx.nam, 'NONE'),    -- PREVIOUS_LOG_NAME VARCHAR2(513)
decode                   -- PREVIOUS_LOG_STATUS VARCHAR2(13)
  (bitand (mx.mrs, 256 + 128 + 64 + 8), 8, 'RELEASE', 64, 'WRONG LOG', 128, 'MISSING NAME', 256, 'UNNEEDED NAME', 'NONE'),
decode                   -- REASON VARCHAR2(13)
  (nvl (fx.err, 3), 1, 'NEED LOG', 3, 'END OF THREAD', 4, 'LOG REUSED', 'UNKNOWN') 
from
x$kcrmx mx,
x$kcrfx fx 
where
fx.thr (+) = mx.thr
home |  up  |  mailbox