select
  inst_id,                                 -- INST_ID NUMBER
  rlrid,                                   -- RECID NUMBER
  rlstm,                                   -- STAMP NUMBER
  rlnam,                                   -- NAME VARCHAR2(513)
  rldst,                                   -- DEST_ID NUMBER
  rlthp,                                   -- THREAD# NUMBER
  rlseq,                                   -- SEQUENCE# NUMBER
  to_number(rlrls),                        -- RESETLOGS_CHANGE# NUMBER
  to_date(                                 -- RESETLOGS_TIME DATE
    rlrlc,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(rlxlc),                        -- RESETLOGS_ID NUMBER
  to_number(rllos),                        -- FIRST_CHANGE# NUMBER
  to_date(                                 -- FIRST_TIME DATE
    rllot,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(rlnxs),                        -- NEXT_CHANGE# NUMBER
  to_date(                                 -- NEXT_TIME DATE
    rlnxt,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  rlbct,                                   -- BLOCKS NUMBER
  rlbsz,                                   -- BLOCK_SIZE NUMBER
  decode(                                  -- CREATOR VARCHAR2(7)
    bitand(rlflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128,'SRMN', 256,'LGWR', 'UNKNOWN'),
  decode(                                  -- REGISTRAR VARCHAR2(7)
    bitand(rlflg, 4), 4, 'RFS', decode(bitand(rlflg, 16+32+64+128+256), 16, 'ARCH', 32, 'FGRD', 64, 'RMAN', 128,'SRMN', 256,'LGWR', 'UNKNOWN')),
  decode(                                  -- ARCHIVED VARCHAR2(3)
    bitand(rlflg, 2),0,'NO','YES'),
  decode(                                  -- APPLIED VARCHAR2(3)
    bitand(rlflg, 1024),0,'NO','YES'),
  decode(                                  -- DELETED VARCHAR2(3)
    bitand(rlflg, 1),0,'NO','YES'),
  decode(                                  -- STATUS VARCHAR2(1)
    bitand(rlflg, 1+2048+4096), 0, 'A', 1, 'D', 2048,'X', 4096,'U', '?'),
  to_date(                                 -- COMPLETION_TIME DATE
    rltsm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- DICTIONARY_BEGIN VARCHAR2(3)
    bitand(rlflg,8192),0,'NO','YES'),
  decode(                                  -- DICTIONARY_END VARCHAR2(3)
    bitand(rlflg,16384),0,'NO','YES'),
  decode(                                  -- END_OF_REDO VARCHAR2(3)
    bitand(rlflg,32768),0,'NO','YES'),
  rltoa,                                   -- ARCHIVAL_THREAD# NUMBER
  decode(                                  -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
    bitand(rlfl2,64),0,'NO','YES'),
  decode(                                  -- COMPRESSED VARCHAR2(3)
    bitand(rlfl2,128),0,'NO','YES'),
  decode(                                  -- FAL VARCHAR2(3)
    bitand(rlflg,512),0,'NO','YES'),
  decode(                                  -- END_OF_REDO_TYPE VARCHAR2(10)
    bitand(rlfl2,256+512+1024), 256, 'TERMINAL', 512, 'ACTIVATION', 1024, 'RESETLOGS', decode(bitand(rlflg,32768),0,'','SWITCHOVER')),
  rldbi                                    -- SOURCE_DBID NUMBER
from
  x$kccrl