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: lost control file..

Re: lost control file..

From: Jyoti N <jnair75_at_hotmail.com>
Date: Tue, 14 Aug 2001 08:41:44 -0700
Message-ID: <F001.00369C49.20010814075052@fatcity.com>


 




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

Original text of this message

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