Skip Headers

Oracle® Database Recovery Manager Reference
10g Release 1 (10.1)

Part Number B10770-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

RC_DATABASE_BLOCK_CORRUPTION

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:

  • ALL ZERO. The block header on disk contained only zeros. The block may be valid if it was never filled and if it is in an Oracle7 file. The buffer will be reformatted to the Oracle8 standard for an empty block.
  • FRACTURED. The block header looks reasonable, but the front and back of the block are different versions.
  • CHECKSUM. The optional check value shows that the block is not self-consistent. It is impossible to determine exactly why the check value fails, but it probably fails because sectors in the middle of the block are from different versions.
  • CORRUPT. The block is wrongly identified or is not a data block (for example, the data block address is missing)
  • LOGICAL. Specifies the range is for logically corrupt blocks. CORRUPTION_CHANGE# will have a nonzero value.