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