Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleted Database Files
Diego Pafumi wrote:
>
> I have a terrible problem. Someone here delete one of the dbf, so I
> can's startup the database. I'm using oracle 7.3 under SUN
> What I need to know is if I have to re-install the application (a lot of
> time !!!!!) or if I have another posibility. I don't have the .dbf in
> the backup (great mistake !!!)
If you are running in ARCHIVE LOG mode then you can create a brand new file and apply all redo since the original file's creation. Since you don't have it in backup I doubt you are in ARCHIVELOG to begin with.
In this case if you just want to bring up the database then:
startup mount
alter database datafile 'xx' offline drop;
at this point you can bring up the database, all data in that file is lost. proper continuation is to export what's left in that tablespace and create a new one, or simply drop that tablespace if this is OK.
There is no easy out of this situation, you delete a file, it's gone... Unless your OS has some kinda of a "waste basket..." like NT has...
good luck,
>
> Diego
--
__ _ _ __ _ _ _ _ ___ ______________________________ (( /\\ /\\ ||) |\V/| /\\ /\\ >/ Principal Performance Engineer_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU
////////////////// Drop x's in email (spam) //////////////////////Received on Fri Nov 13 1998 - 19:08:47 CST