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') from x$kccfc

home |  up  |  mailbox