数据块坏？？？

前二天在客户那边，看到通篇都是报数据块坏的问题......[@more@]

***

Corrupt block relative dba: 0x030274a9 (file 12, block 160937)

Bad header found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x030274c8

last change scn: 0x0006.2b80bdb4 seq: 0x1 flg: 0x06

consistency value in tail: 0xbdb40601

check value in block header: 0x95d5, computed block checksum: 0x0

spare1: 0x0, spare2: 0x0, spare3: 0x0

***

Reread of rdba: 0x030274a9 (file 12, block 160937) found valid data

***

Corrupt block relative dba: 0x030274aa (file 12, block 160938)

Bad header found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x030274c9

last change scn: 0x0000.0004c006 seq: 0x1 flg: 0x06

consistency value in tail: 0xc0060601

check value in block header: 0xd32b, computed block checksum: 0x0

spare1: 0x0, spare2: 0x0, spare3: 0x0

***

Reread of rdba: 0x030274aa (file 12, block 160938) found valid data

***

Corrupt block relative dba: 0x030274ab (file 12, block 160939)

Bad header found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x030274ca

last change scn: 0x0006.167f8614 seq: 0x1 flg: 0x06

consistency value in tail: 0x86140601

check value in block header: 0x73e7, computed block checksum: 0x0

spare1: 0x0, spare2: 0x0, spare3: 0x0

***

看到上面的提示，大家都认为是数据块坏吧！！！！！可通过DBV、RMAN都没有办法找到坏的数据块，用户也反映在执行一些select语句的时候，也无法读取数据，进程死翘翘的那边一动不动，折磨了半天，最后发现是ORACLE9201的BUG！！！

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

转载于:http://blog.itpub.net/814/viewspace-855726/