RE: emergency rescue needed

If you have no other solution and can sacrifice some of the corruptede = data, you can do:

startup restrict mount;
ALTER DATABASE DATAFILE '/u05/oradata/bla/bla.dbf' OFFLINE drop;

-----Original Message-----

From: sol beach [mailto:sol.beach_at_gmail.com] Sent: Monday, February 07, 2005 2:10 AM
To: Oracle-L Freelists
Subject: emergency rescue needed

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
--

http://www.freelists.org/webpage/oracle-l Received on Mon Feb 07 2005 - 02:13:20 CST