当前位置: 代码迷 >> Oracle技术 >> Corrupt block relative dba: 0x01400083 (file 5, block 131)解决方案
  详细解决方案

Corrupt block relative dba: 0x01400083 (file 5, block 131)解决方案

热度:623   发布时间:2016-04-24 08:36:08.0
Corrupt block relative dba: 0x01400083 (file 5, block 131)
数据库提示有坏块,Corrupt block relative dba: 0x01400083 (file 5, block 131),alert文件和.trc文件记录的都是这个错误,但是在查找时候找不到?!
贴出alert日志部分:
Dump file d:\oracle\product\10.2.0\admin\haph\bdump\haph_smon_3264.trc
Tue Nov 29 18:05:38 2011
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
Windows NT Version V6.0 Service Pack 1
CPU : 16 - type 8664, 16 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:13436M/16381M, Ph+PgF:20201M/32558M
Instance name: haph

Redo thread mounted by this instance: 1

Oracle process number: 9

Windows thread id: 3264, image: ORACLE.EXE (SMON)


*** 2011-11-29 18:05:38.206
*** SERVICE NAME:(SYS$BACKGROUND) 2011-11-29 18:05:38.206
*** SESSION ID:(548.1) 2011-11-29 18:05:38.206
Hex dump of (file 5, block 131)
Dump of memory from 0x000000019D178000 to 0x000000019D17A000
19D178000 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1781F0 00000000 00000000 00000000 10100000 [................]
19D178200 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1783F0 00000000 00000000 00000000 10100000 [................]
19D178400 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1785F0 00000000 00000000 00000000 10100000 [................]
19D178600 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1787F0 00000000 00000000 00000000 10100000 [................]
19D178800 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1789F0 00000000 00000000 00000000 10100000 [................]
19D178A00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D178BF0 00000000 00000000 00000000 10100000 [................]
19D178C00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D178DF0 00000000 00000000 00000000 10100000 [................]
19D178E00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D178FF0 00000000 00000000 00000000 10100000 [................]
19D179000 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1791F0 00000000 00000000 00000000 10100000 [................]
19D179200 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1793F0 00000000 00000000 00000000 10100000 [................]
19D179400 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1795F0 00000000 00000000 00000000 10100000 [................]
19D179600 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1797F0 00000000 00000000 00000000 10100000 [................]
19D179800 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D1799F0 00000000 00000000 00000000 10100000 [................]
19D179A00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D179BF0 00000000 00000000 00000000 10100000 [................]
19D179C00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D179DF0 00000000 00000000 00000000 10100000 [................]
19D179E00 00000000 00000000 00000000 00000000 [................]
  Repeat 30 times
19D179FF0 00000000 00000000 00000000 10100000 [................]


在下边就是重复记录,追踪文件记录的也一样的东西,查找select owner,segment_name,segment_type from dba_extents where file_id=5 and 131 between block_id and block_id+blocks-1;返回为空,单找FILE=5能找的到,找坏块就找不出来。郁闷啊,各位大师给定建议啥的。。。。。。。
  相关解决方案