ORA-01172、ORA-01151错误处理

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

遇到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"

ClipDrop

Stability.AI出品的图片处理系列工具（背景移除、图片放大、打光）

112

查看详情

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