Hi Saurabh,
After deleting the original control file , did you replace it with the newly created copy with same name path etc.?
HTH.
Jyoti
>From: "Saurabh Sharma"
>Reply-To: ORACLE-L@fatcity.com
>To: Multiple recipients of list ORACLE-L
>Subject: lost control file..
>Date: Tue, 14 Aug 2001 04:50:27 -0800
>
>hi all,
>i was experimenting with my test db, and trying to recover the control file.
>i taken backup of control file as
>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
>and also
>ALTER DATABASE BACKUP CONTROLFILE TO 'NEW LOCATION';
>
>i then shutdown normal, removed the controlfile from its original location and tried STARTUP
>it gave me this error..
>ORA-00205: error in identifying controlfile, check alert log for more info.
>
>after i done shutdown normal and tried another restart
>but agin error is..
>ORA-01102: cannot mount database in EXCLUSIVE mode
>
>how can i recover my control file now. should i need be in mount stage, or should i recreate controlfile using backup from trace.
>
>pls throw some light on what are different options available now.
>
>Saurabh Sharma
>
>saurabh00pc@yahoo.com
>http://www.geocities.com/saurabh00pc/stride.html
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jyoti N
INET: jnair75@hotmail.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@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 Tue Aug 14 2001 - 10:41:44 CDT
