V$DATABASE_BLOCK_CORRUPTION
displays information about database blocks that were corrupted after the last backup.
Column | Datatype | Description |
---|---|---|
FILE# |
NUMBER |
Absolute file number of the datafile that contains the corrupt blocks |
BLOCK# |
NUMBER |
Block number of the first corrupt block in the range of corrupted blocks |
BLOCKS |
NUMBER |
Number of corrupted blocks found starting with BLOCK# |
CORRUPTION_CHANGE# |
NUMBER |
Change number at which the logical corruption was detected. Set to 0 to indicate media corruption. |
CORRUPTION_TYPE |
VARCHAR2(9) |
Type of block corruption in the datafile:
|