RE: Datafile offline, urgent

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Wed, 4 Oct 2000 00:27:24 -0700
Message-Id: <10639.118433@fatcity.com>

well if u do not care about the contents of the new datafile and assuming this is a test db :) do the following

alter database backup controlfile to trace;
edit the control file fron udump trace location and remove refernces of this new file
run this file to recreate the control file.
use OS command to physically remove file ..

am having a brain fart and thats all i can think at this weeee hr :)

hth
deepAk

-----Original Message-----
From: Mahmoud Reza Zare [mailto:mrezair_at_0racledba.com] Sent: Wednesday, October 04, 2000 12:36 AM To: Multiple recipients of list ORACLE-L Subject: Datafile offline, urgent

Dear List Reader,

I have my DB running in ARCHIVELOG mode and I added a datafile to one of my tablespaces and mistakenly took it offline. Now I can not take it back online.
At first it prompted that your file requires media recovery. I executed 'Ater database recover automatic' on the datafile. It did not work and now I do not know how to stop recovery process or even to drop the datafile. I can not shutdown the database.

Thanks a lot
Mahmoud

Be someone_at_0racledba.com - get your free mail from Oriole Corporation http://www.oriolecorp.com - Performance tools for Oracle DBAs

Get email for your site ---> http://www.everyone.net

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mahmoud Reza Zare
INET: mrezair_at_0racledba.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 04 2000 - 02:27:24 CDT