GV$BACKUP_REDOLOG

select
inst_id,                 -- INST_ID NUMBER
blrid,                   -- RECID NUMBER
blstm,                   -- STAMP NUMBER
blbss,                   -- SET_STAMP NUMBER
blbsc,                   -- SET_COUNT NUMBER
blthp,                   -- THREAD# NUMBER
blseq,                   -- SEQUENCE# NUMBER
to_number (blrls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (blrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (bllos),       -- FIRST_CHANGE# NUMBER
to_date                  -- FIRST_TIME DATE
  (bllot, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (blnxs),       -- NEXT_CHANGE# NUMBER
to_date                  -- NEXT_TIME DATE
  (blnxt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
blbct,                   -- BLOCKS NUMBER
blbsz                    -- BLOCK_SIZE NUMBER
from
x$kccbl
home |  up  |  mailbox