ITPub博客

首页 > 数据库 > 数据库开发技术 > 数据块坏???

数据块坏???

原创 数据库开发技术 作者:rwq_ 时间:2006-08-12 02:49:39 0 删除 编辑
前二天在客户那边,看到通篇都是报数据块坏的问题......[@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

***

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

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

上一篇: 数据库open过程
请登录后发表评论 登录
全部评论
  • 博文量
    36
  • 访问量
    637338