Archive for February, 2013

Oracle Datafile Recovery (ORA-01172)

February 19, 2013 Leave a comment

Today, i Face a problem on oracle db server. the symptoms are :

  1. Try to login, but exception thrown,  said ‘ORA-01033: ORACLE initialization or shutdown in progress’
  2. Try to check listener status, result : Listener is running but nothing weird
  3. 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 :

  1. Connect as sysdba
  2. 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 :  Id
  3. The result shows datafile need to be recovered
  4. To recover the datafile, invoke the following command ‘recover datafile 3’ , The id come from file id above. -
  5. 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




Categories: Database Tags: ,