Re: Database file deleted !!!

Jan Kopinec <kopinec_at_ips-ag.ch> writes:

>On our ORACLE NT7.3 when the database
>was done the almoust empty database file was deleted but we did
>forget to delete its tablespace like the first. Is here any way how
>to start-up (open) the database and at least export the data
>out!
> Just to put up some similar "old-like" file insted of deleted one
>does not
>help because there is a lot of checking when the ORACLE server opens
>the database and it allways fails with any error message!

If you meant to drop the database file (you were all done with teh data in the tablespace the file was for), but just forgot to drop the tablespace in the database before dropping the datafile, the solution is easy:

startup database mount
alter database datafile 'XXX' offline drop; (where XXX is your datafile name) alter database open;
drop tablespace XXX (where XXX is the ts the datafile belonged to)

Note that you are not doing anything with the OS files here - you are merely changing the controlfile and data dictionary entries.

If you did not mean to drop the datafile, you'll have to recover the datafile from backup, and perform Oracle media recovery. Received on Tue Sep 16 1997 - 00:00:00 CDT