From jnair75@hotmail.com Tue, 14 Aug 2001 08:41:44 -0700 From: "Jyoti N" Date: Tue, 14 Aug 2001 08:41:44 -0700 Subject: Re: lost control file.. Message-ID: MIME-Version: 1.0 Content-Type: text/html   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).