GV$DATAFILE_COPY

select
inst_id,                 -- INST_ID NUMBER
dcrid,                   -- RECID NUMBER
dcstm,                   -- STAMP NUMBER
dcnam,                   -- NAME VARCHAR2(513)
dctag,                   -- TAG VARCHAR2(32)
dcdfp,                   -- FILE# NUMBER
dcrfn,                   -- RFILE# NUMBER
to_number (dccrs),       -- CREATION_CHANGE# NUMBER
to_date                  -- CREATION_TIME DATE
  (dccrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (dcrls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (dcrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- INCREMENTAL_LEVEL NUMBER
  (bitand (dcflg, 8), 8, 0, NULL),
to_number (dccps),       -- CHECKPOINT_CHANGE# NUMBER
to_date                  -- CHECKPOINT_TIME DATE
  (dccpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (dcafs),       -- ABSOLUTE_FUZZY_CHANGE# NUMBER
to_number (dcrfs),       -- RECOVERY_FUZZY_CHANGE# NUMBER
to_date                  -- RECOVERY_FUZZY_TIME DATE
  (dcrft, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- ONLINE_FUZZY VARCHAR2(3)
  (bitand (dcflg, 2), 0, 'NO', 'YES'),
decode                   -- BACKUP_FUZZY VARCHAR2(3)
  (bitand (dcflg, 4), 0, 'NO', 'YES'),
dcncb,                   -- MARKED_CORRUPT NUMBER
dcmcb,                   -- MEDIA_CORRUPT NUMBER
dclcb,                   -- LOGICALLY_CORRUPT NUMBER
dcbct,                   -- BLOCKS NUMBER
dcbsz,                   -- BLOCK_SIZE NUMBER
dclor,                   -- OLDEST_OFFLINE_RANGE NUMBER
decode                   -- DELETED VARCHAR2(3)
  (bitand (dcflg, 1), 0, 'NO', 'YES'),
decode                   -- STATUS VARCHAR2(1)
  (bitand (dcflg, 1+32+64), 0, 'A', 1, 'D', 32, 'X', 64, 'U', '?'),
to_date                  -- COMPLETION_TIME DATE
  (dctsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- CONTROLFILE_TYPE VARCHAR2(1)
  (dcdfp, 0, decode (bitand (dcflg, 16), 16, 'S', 'B'), NULL),
decode                   -- KEEP VARCHAR2(3)
  (bitand (dcflg, 1792), 0, 'NO', 'YES'),
to_date                  -- KEEP_UNTIL DATE
  (dckpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- KEEP_OPTIONS VARCHAR2(10)
  (bitand (dcflg, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'CONSISTENT', NULL),
decode                   -- SCANNED VARCHAR2(3)
  (bitand (dcflg, 128), 0, 'NO', 'YES'),
decode                   -- IS_RECOVERY_DEST_FILE VARCHAR2(3)
  (bitand (dcflg, 2048), 0, 'NO', 'YES'),
dcrsi,                   -- RMAN_STATUS_RECID NUMBER
dcrst                    -- RMAN_STATUS_STAMP NUMBER
from
x$kccdc
home |  up  |  mailbox