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