select
RECID, -- RECID NUMBER
STAMP, -- STAMP NUMBER
SET_STAMP, -- SET_STAMP NUMBER
SET_COUNT, -- SET_COUNT NUMBER
PIECE#, -- PIECE# NUMBER
FILE#, -- FILE# NUMBER
BLOCK#, -- BLOCK# NUMBER
BLOCKS, -- BLOCKS NUMBER
CORRUPTION_CHANGE#, -- CORRUPTION_CHANGE# NUMBER
MARKED_CORRUPT, -- MARKED_CORRUPT VARCHAR2(3)
CORRUPTION_TYPE -- CORRUPTION_TYPE VARCHAR2(9)
from
GV$BACKUP_CORRUPTION
where
inst_id = USERENV('Instance')