| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: lost control file..
I don't even have the excuse of it being too early and before I've had coffee... especially since I've done the copy route a number of times.
sigh......... thanks Tom!
>From: "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: lost control file..
>Date: Tue, 14 Aug 2001 07:01:57 -0800
>
>
>Rachel says:
>
>"Oracle has to have at least ONE controlfile to open. If you have more than
>one, and deleted only one, you can edit the init.ora and change the
>controlfiles parameter to remove the one that is missing."
>
>
>OR, if you have another control file available, simply copy and rename it
>to
>the one that is missing and re-start your database.
>
>Tom Mercadante
>Oracle Certified Professional
>
>
>-----Original Message-----
>Sent: Tuesday, August 14, 2001 10:00 AM
>To: Multiple recipients of list ORACLE-L
>
>
>recreate the control file from the trace one.
>
>Oracle has to have at least ONE controlfile to open. If you have more than
>one, and deleted only one, you can edit the init.ora and change the
>controlfiles parameter to remove the one that is missing.
>
>
> >From: "Saurabh Sharma" <ssharma1_at_fcsltd.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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_at_yahoo.com
> >http://www.geocities.com/saurabh00pc/stride.html
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_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_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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_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_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 Tue Aug 14 2001 - 13:05:00 CDT
 |
 |