block corruption type

Type of block corruption in the datafile:

• ALL ZERO - 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 - Block header looks reasonable, but the front and back of the block are different versions.

• CHECKSUM - 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 - 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.

[@more@]

SQL> desc v$database_block_corruption
名称 是否为空? 类型
----------------------------------------- -------- ----------------------------

FILE# NUMBER
BLOCK# NUMBER
BLOCKS NUMBER
CORRUPTION_CHANGE# NUMBER
CORRUPTION_TYPE VARCHAR2(9)

SQL> select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO
---------- ---------- ---------- ------------------ ---------
2 315 1 0 CHECKSUM
2 240 1 0 CORRUPT
2 239 1 0 FRACTURED
2 455 1 0 CHECKSUM

SQL>

模拟block corruption无意中编辑了block 239的tail和block240的header，结果很容易的看到了block corruption typy里面的CORRUPT和FRACTURED，通常我们可以非常容易的看到CHECKSUM

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19602/viewspace-1036420/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19602/viewspace-1036420/