Because the server suddenly loses power, the database cannot be started after the machine is restarted.
Database Version Oracle10201, OS RedHat 5.4
No database archive and no backup [oracle @ hunan02 ~] $ Sqlplus/nologSQL * Plus: Release 10.2.0.1.0-Production on Tue Jun 28 10:37:03 2011 Copyright (c) 1982,200 5, Oracle. All rights reserved. SQL> conn/as sysdba
Connected. SQL> select open_mode from v $ database; OPEN_MODE
----------
MOUNTED tries to open the database
SQL> alter database open;
Alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 3651180 of file 8
ORA-01151: use media recovery to recover block, restore backup if neededSQL> select file #, name from v $ datafile where file # = 8;FILE #
----------
NAME
--------------------------------------------------------------------------------
8
/Oradata2/users01_6.dbf
SQL> recover datafile 8; // recovery successful
Media recovery complete.Recover restores readable information from the damaged disk.