Re: Help: Datafile toasted; how do you get Oracle running again?

In <43n9tc$ctt_at_symiserver.symantec.com>, mwu_at_tlsolutions.com (Matt Wu) writes:
>
>Okay, someone decided to go ahead and delete a file that contained the
>rollback tablespace. Is there a way to resurrect the database? If not, is
>there a way to connect to the database so that the files can be recreated?
>
>Fortunately, the data isn't important -- it's just a test database -- but I'd
>really prefer to find a better way of re-creating the database than
>re-installing Oracle, which is what we've been doing lately.
>
>I thought this could be done by editing the INIT.ORA file, but haven't had any
>luck with that.
>
>Thanks,
>
>Matt
>mwu_at_tlsolutions.com

I personally have not had to try this, but you may be able to issue:

alter database create datafile '\path\oldfilename' as '\path\newfilename';

You may have to create the file oldfilename; any type of file should work because by using this command Oracle will know that the file is damaged and unusable. Basically, what this command does is create a empty database file (assuming your control files are not damaged) that allows you to at least get the database running. If this procedure is successful the next step would be to drop your rollback segment tablespace and then recreate it.

M.Landa Received on Fri Sep 22 1995 - 00:00:00 CEST