I had a situation today where my database would not start because “someone” had deleted a datafile. While deleting the datafile at the OS level was probably not a particularly good decision, things like this do happen occasionally, so how to get the database back up?
Here is the error message when the database refused to start:
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file ORA-01110: data file 14: 'C:\DATABASE\ORADATA\ORCL\CDBWKLW.DBF'
This command is the quickest and easiest way to get rid of the problem:
alter database datafile 'c:\database\oradata\orcl\cdbwklw.dbf' offline drop ;
After this the database will start happily. You may need to drop the tablespace too.