GV$BACKUP_REDOLOG definition in Oracle Database 11.2
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
  decode(                                  -- TERMINAL VARCHAR2(3)
    bitand(blflg, 1), 1, 'YES', 'NO') 
from
  x$kccbl
where
  bitand(blflg, 2) != 2

home |  up