GV$BACKUP_DATAFILE definition in Oracle 10g / www.oracledba.ru
GV$BACKUP_DATAFILE
select
inst_id, -- INST_ID NUMBER
bfrid, -- RECID NUMBER
bfstm, -- STAMP NUMBER
bfbss, -- SET_STAMP NUMBER
bfbsc, -- SET_COUNT NUMBER
bfdfp, -- FILE# NUMBER
to_number (bfcrs), -- CREATION_CHANGE# NUMBER
to_date -- CREATION_TIME DATE
(bfcrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (bfrls), -- RESETLOGS_CHANGE# NUMBER
to_date -- RESETLOGS_TIME DATE
(bfrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- INCREMENTAL_LEVEL NUMBER
(bitand (bfflg, 1), 1, bflvl, NULL),
to_number (bfics), -- INCREMENTAL_CHANGE# NUMBER
to_number (bfcps), -- CHECKPOINT_CHANGE# NUMBER
to_date -- CHECKPOINT_TIME DATE
(bfcpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (bfafs), -- ABSOLUTE_FUZZY_CHANGE# NUMBER
bfncb, -- MARKED_CORRUPT NUMBER
bfmcb, -- MEDIA_CORRUPT NUMBER
bflcb, -- LOGICALLY_CORRUPT NUMBER
bffsz, -- DATAFILE_BLOCKS NUMBER
bfbct, -- BLOCKS NUMBER
bfbsz, -- BLOCK_SIZE NUMBER
bflor, -- OLDEST_OFFLINE_RANGE NUMBER
to_date -- COMPLETION_TIME DATE
(bftsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- CONTROLFILE_TYPE VARCHAR2(1)
(bfdfp, 0, decode (bitand (bfflg, 2), 2, 'S', 'B'), NULL),
decode -- USED_CHANGE_TRACKING VARCHAR2(3)
(bitand (bfflg, 4), 4, 'YES', 'NO'),
bfbrd -- BLOCKS_READ NUMBER
from
x$kccbf