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+8192), 16, bslvl, NULL),
bspct,                   -- PIECES NUMBER
to_date                  -- START_TIME DATE
  (bsbst, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- COMPLETION_TIME DATE
  (bitand (bstyp, 4096), 4096, to_date (bsbst, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'), to_date (bstsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')),
decode                   -- ELAPSED_SECONDS NUMBER
  (bitand (bstyp, 4096), 4096, 0, abs ((to_date (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'),
decode                   -- KEEP VARCHAR2(3)
  (bitand (bstyp, 1792), 0, 'NO', 'YES'),
to_date                  -- KEEP_UNTIL DATE
  (bskpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- KEEP_OPTIONS VARCHAR2(10)
  (bitand (bstyp, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'CONSISTENT', NULL) 
from
x$kccbs 
where
bitand (bstyp, 32) != 32
home |  up  |  mailbox