ORA-01172、ORA-01151错误处理

遇到ORA-01172、ORA-01151错误，询问得知存储出现故障导致数据库无法启动。数据库版本：10.2.0.1.0[Oracle@hhserverfs ~]$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 8 11:46:38 2013Copyright （c） 1982, 2005, Oracle. All rights reserved.SQL> conn /as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 1124073472 bytesFixed Size 1218968 bytesVariable Size 385877608 bytesDatabase Buffers 721420288 bytesRedo Buffers 15556608 bytesDatabase mounted.ORA-01172: recovery of thread 1 stuck at block 121 of file 2ORA-01151: use media recovery to recover block, restore backup if neededSQL> ！[oracle@hhserverfs ~]$ oerr ora 0117201172, 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 ~]$ exitexitSQL> recover datafile 2;Media recovery complete.SQL> alter database open;Database altered.SQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options[oracle@hhserverfs ~]$更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12ORA-00600 [2662]错误解决Oracle数据库启动时出现ORA-01157和ORA-01110问题相关资讯 ORA-01172 ORA-01151 本文评论查看全部评论（0）