emergency rescue needed

  • From: sol beach <sol.beach@xxxxxxxxx>
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 6 Feb 2005 17:10:14 -0800

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.
--
//www.freelists.org/webpage/oracle-l

Other related posts: