Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Sun Feb 06 2005 - 20:13:09 CST
![]() |
![]() |