RE: emergency rescue needed
- From: Sonja Šehović <sonja.sehovic@xxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Feb 2005 08:08:55 +0100
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@xxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
