ORA-01172、ORA-01151错误处理

2014-11-24 17:54:42 · 作者: · 浏览: 0

遇到ORA-01172、ORA-01151错误,询问得知存储出现故障导致数据库无法启动。


数据库版本:10.2.0.1.0


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