GV$BACKUP_CORRUPTION
select inst_id, -- INST_ID NUMBER fcrid, -- RECID NUMBER fcstm, -- STAMP NUMBER fcbss, -- SET_STAMP NUMBER fcbsc, -- SET_COUNT NUMBER fcpno, -- PIECE# NUMBER fcdfp, -- FILE# NUMBER fcblk, -- BLOCK# NUMBER fccnt, -- BLOCKS NUMBER to_number (fcscn), -- CORRUPTION_CHANGE# NUMBER decode -- MARKED_CORRUPT VARCHAR2(3) (bitand (fcflg, 1), 1, 'YES', 'NO'), decode -- CORRUPTION_TYPE VARCHAR2(9) (bitand (fcflg, 30), 2, 'ALL ZERO', 4, 'FRACTURED', 8, 'CHECKSUM', 16, 'CORRUPT', decode (to_number (fcscn), 0, 'UNKNOWN', 'LOGICAL')) from x$kccfc

home |  up  |  mailbox