Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> emergency rescue needed

emergency rescue needed

From: sol beach <sol.beach_at_gmail.com>
Date: Sun, 6 Feb 2005 17:10:14 -0800
Message-ID: <40a16b36050206171057028339@mail.gmail.com>


I had/have a test DB where a number of files got corrupted. I just HAVE be able to open this DB.
I am willing to sacrafice the data in the corrupted files. What are the steps to do so?
It is something along the lines of STARTUP NOMOUNT ALTER TABLESPACE ???? OFFLINE;
DROP TABLESPACE ?????;
STARTUP MOUNT;
ALTER DATABASE OPEN; I've just looked in Metalink & did not find where this procedure is documented.

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Feb 06 2005 - 20:13:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US