This view gives information about database blocks that were corrupted after the last backup. It corresponds to the V$DATABASE_BLOCK_CORRUPTION
view.
Column | Datatype | Description |
---|---|---|
DB_KEY |
NUMBER |
The primary key for the database. Use this column to form a join with almost any other catalog view. |
DBINC_KEY |
NUMBER |
The primary key for the current incarnation. Use this column to form a join with RC_DATABASE_INCARNATION . |
FILE# |
NUMBER |
The absolute file number of the datafile. |
BLOCK# |
NUMBER |
The block number of the first corrupted block in this range of corrupted blocks. |
BLOCKS |
NUMBER |
The number of corrupted blocks found beginning with BLOCK# . |
CORRUPTION_CHANGE# |
NUMBER |
For media corrupt blocks, this value is zero. For logically corrupt blocks, this value is the lowest SCN in the blocks in this corrupt range. |
CORRUPTION_TYPE |
VARCHAR2(9) |
The type of block corruption in the datafile. Possible values are:
|