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

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

RE: emergency rescue needed

From: Sonja Šehović <sonja.sehovic_at_pbz.hr>
Date: Mon, 7 Feb 2005 08:08:55 +0100
Message-ID: <B3772712305A314CAB52855AF8F2739613BA9BE8@ksdcexc01.sit.pbz.hr>


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

Original text of this message

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