Today, i Face a problem on oracle db server. the symptoms are :
- Try to login, but exception thrown, said ‘ORA-01033: ORACLE initialization or shutdown in progress’
- Try to check listener status, result : Listener is running but nothing weird
- Try to open database manualy using command : ‘alter dabase open’, exception raised, ‘ORA-01172 : recovery of thread 1 stuck at block 747 of file 3’
To resolve this problem , the steps are :
- Connect as sysdba
- invoke following command : ‘select name, status, enabled from v$datafile where file#=3‘. The id come from file id raised in ORA-01172. The Result :
- The result shows datafile need to be recovered
- To recover the datafile, invoke the following command ‘recover datafile 3’ , The id come from file id above.
- Then invoke command to open database.
Voilaa .. now i can login to my oracle box without problem.
#NB : Don’t forget to backup database regularly, using hot backup or cold backup.
Jakarta WEBS Tower
Tuesday, 19 Februari 2012
A. Ahmad Kusumah