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


/forum/fa/6433/0/

Report message to a moderator

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: 4581
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.

Report message to a moderator

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: 4963
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.

Report message to a moderator

Previous Topic: Oracle errors: additional information
Next Topic: USER1234 dedicated to instance PROD1 (merged 6)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 17:23:40 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.