GV$BACKUP_SET

select
inst_id,                 -- INST_ID NUMBER
bsrid,                   -- RECID NUMBER
bsstm,                   -- STAMP NUMBER
bsbss,                   -- SET_STAMP NUMBER
bsbsc,                   -- SET_COUNT NUMBER
decode                   -- BACKUP_TYPE VARCHAR2(1)
  (bitand (bstyp, 11), 1, 'D', 2, 'I', 8, 'L'),
decode                   -- CONTROLFILE_INCLUDED VARCHAR2(3)
  (bitand (bstyp, 4+64), 4, 'YES', 68, 'SBY', 'NO'),
decode                   -- INCREMENTAL_LEVEL NUMBER
  (bitand (bstyp, 16), 16, bslvl, NULL),
bspct,                   -- PIECES NUMBER
to_date                  -- START_TIME DATE
  (bsbst, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- COMPLETION_TIME DATE
  (bstsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
(to_date                 -- ELAPSED_SECONDS NUMBER
  (bstsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') - to_date (bsbst, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')) *86400,
bsbsz,                   -- BLOCK_SIZE NUMBER
decode                   -- INPUT_FILE_SCAN_ONLY VARCHAR2(3)
  (bitand (bstyp, 128), 128, 'YES', 'NO') 
from
x$kccbs
home |  up  |  mailbox