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

From: Matt Wu <mwu_at_tlsolutions.com>
Date: 1995/09/19
Message-ID: <43n9tc$ctt_at_symiserver.symantec.com>#1/1

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 Received on Tue Sep 19 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Rajasekaran Rangarajan: "HELP!!!! INDEXES and SQL Loader"
Previous message: Sridhar Subramaniam: "Re: How to release acquired locks"
Next in thread: mlanda_at_vnet.ibm.com: "Re: Help: Datafile toasted; how do you get Oracle running again?"
Reply: Paul Baumgartel: "Re: Help: Datafile toasted; how do you get Oracle running again?"
Maybe reply: Matt Wu: "Re: Help: Datafile toasted; how do you get Oracle running again?"
Reply: Sybrand Bakker: "Re: Help: Datafile toasted; how do you get Oracle running again?"
Reply: mlanda_at_vnet.ibm.com: "Re: Help: Datafile toasted; how do you get Oracle running again?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message