数据库版本:11.1.0.7.0
操作系统版本:linux6
数据库启动在mount状态,后台日志无报错,显示正在做recovery,hang住:
Mon Nov 18 09:30:08 2013
alter database open
Beginning crash recovery of 1 threads
Started redo scan
Completed redo scan
319186 redo blocks read, 37950 data blocks need recovery
通过对数据库进行10046tracce分析、hanganalyze分析均无结果。
最后对数据文件进行dbv,发现有坏块:
DBVERIFY - 开始验证: FILE = /dev/raw/raw104
页 353108 标记为损坏
Corrupt block relative dba: 0x10856354 (file 66, block 353108)
Completely zero block found during dbv:
页 353109 标记为损坏
Corrupt block relative dba: 0x10856355 (file 66, block 353109)
Completely zero block found during dbv:
页 353110 标记为损坏
Corrupt block relative dba: 0x10856356 (file 66, block 353110)
Completely zero block found during dbv:
DBVERIFY