Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

one of the datafile was accidently deleted...database won't start

Deanna Tran_1
Frequent Advisor

one of the datafile was accidently deleted...database won't start

This is the error code that I got when I try to reopen the database...Can anyone help me to fix this ???

oerr ora 01157
157, 00000, "cannot identify/lock data file %s - see DBWR trace file"
*Cause: The background process was either unable to find one of the
files or failed to lock it because the file was already in us
The database will prohibit access to this file but other file
be unaffected. However the first instance to open the databas
need to access all online data files. Accompanying error from
operating system describes why the file could not be identifi
*Action: Have operating system make file available to database. Then
open the database or do ALTER SYSTEM CHECK DATAFILES.
cd /tablespace_rollback
4 REPLIES
Jeanine Kone
Trusted Contributor

Re: one of the datafile was accidently deleted...database won't start

OK - first do you know which specific file is missing? Have you verfied that it is gone? Do you have a backup?

How you proceed will depend upon which file and if you are able to recover it....

If you can't recover it, you may be able to mount, offline the tablespace, and open without it.
Deanna Tran_1
Frequent Advisor

Re: one of the datafile was accidently deleted...database won't start

hi....
OK - first do you know which specific file is missing? Have you verfied that it is gone? Do you have a backup? yes...that file is no longer
in my directory...i have check on the o/s level... and no, i didn't have back up for this...this file is part of the tablespace for rollback

How you proceed will depend upon which file and if you are able to recover it....

If you can't recover it, you may be able to mount, offline the tablespace, and open without it.

*** hi....i can't do either of that..can't take
the tablespace offline because it is not open...
Jeanine Kone
Trusted Contributor

Re: one of the datafile was accidently deleted...database won't start

Well, I don't know if this will work, but here is what I would try:

1) create a new (empty) datafile to replace the one you lost.
2) mount, but do not open the database
3) do a "recover datafile xyz;"

Are you running in archive log mode? If so, do you have the archived log files?
Brian Bientz
Advisor

Re: one of the datafile was accidently deleted...database won't start

If you have access to the Oracle documentation, look in the Oracle8i Backup and Recovery Guide. Chapter 6 is "Media Recovery Scenarios" and there is a section called "Recovering after the loss of datafiles".

If you don't have this documentation you go to technet.oracle.com.

Finally, if you have a support contract I would recommend calling Oracle support and they will walk you through the recovery process.