遇到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 ~]$