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