Home » RDBMS Server » Server Administration » ora-01157:cannot identify/lock data file 12 - see DBWR trace file (ORACLE V9.2.0.1.0 - Production vsnsta=0,win xp)
ora-01157:cannot identify/lock data file 12 - see DBWR trace file [message #411061] Wed, 01 July 2009 14:37 Go to next message
deepan_g
Messages: 12
Registered: May 2008
Junior Member
hi,
i mistakenly deleted one of the datafile and when i tried to start the database it gives an error
ERROR at line 1:
ORA-01157: cannot identify/lock data file 12 - see DBWR trace file
ORA-01110: data file 12: 'E:\ORACLE\ORADATA\C_MYDB\INDEX01.DBF'
my database is on standalone computer in noarchivelog mode.

please help me solve the problem.
thankyou


./fa/6433/0/
Re: ora-01157:cannot identify/lock data file 12 - see DBWR trace file [message #411062 is a reply to message #411061] Wed, 01 July 2009 14:43 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Take the datafile offline and start the DB. Something like:

ALTER DATABASE DATAFILE ... OFFLINE DROP;

When done, drop the tablespace, recreate it and recreate the indexes.
Re: ora-01157:cannot identify/lock data file 12 - see DBWR trace file [message #411067 is a reply to message #411062] Wed, 01 July 2009 15:21 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Just to add to Frank's message, you of course would need to bring up the database in mount mode only, since you get the error message when you try to open/start it.

Hopefully, you only had indexes in that tablespace and know what all of them were. just becuase it's called INDEX01.dbf does not mean it didn't have tables in it.
Previous Topic: Oracle errors: additional information
Next Topic: USER1234 dedicated to instance PROD1 (merged 6)
Goto Forum:
  


Current Time: Sat Dec 10 18:59:05 CST 2016

Total time taken to generate the page: 0.08723 seconds