Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Datafile offline, urgent
well if u do not care about the contents of the new datafile and assuming
this is a test db :) do the following
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
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
![]() |
![]() |