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