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) 
from
x$kccbf
home |  up  |  mailbox