遇到ORA-01172、ORA-01151错误,询问得知存储出现故障导致数据库无法启动。
数据库版本:10.2.0.1.0
[oracle@hhserverfs ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 8 11:46:38 2013 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1124073472 bytes Fixed Size 1218968 bytes Variable Size 385877608 bytes Database Buffers 721420288 bytes Redo Buffers 15556608 bytes Database mounted. ORA-01172: recovery of thread 1 stuck at block 121 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed SQL> ! [oracle@hhserverfs ~]$ oerr ora 01172 01172, 00000, "recovery of thread %s stuck at block %s of file %s" // *Cause: Crash recovery or instance recovery could not apply a change to a // block because it was not the next change. This can happen if the // block was corrupted and then repaired during recovery. // *Action: Do a RECOVER DATAFILE for the file containing the block. If this // does not resolve the problem then restore the file from a backup // and recover it. [oracle@hhserverfs ~]$ exit exit SQL> recover datafile 2; Media recovery complete. SQL> alter database open; Database altered. SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr oduction With the Partitioning, OLAP and Data Mining options [oracle@hhserverfs ~]$