ORA-01172, ORA-01151 error handling

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start.

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start.

Encountered a ORA-01172, ORA-01151 error, asked about the storage failure caused the database to fail to start.

Database Version: 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,200 5, 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 1, 01172

01172,000 00, "recovery of thread % s stuck at block % s of file % s"

// * Cause: Crash recovery or instance recovery cocould not apply a change to

// Block because it was not the next change. This can happen if

// Block was upload upted and then retries red 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 ~] $

,