日期:2014-05-16  浏览次数:21186 次

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 fr