Hi , Some precisions :
If you have ONLY LOST the controlfiles after a clean shutdown (normal or immediate) you can just : 1) startup nomount 2) recreate the controfiles (CREATE CONTROLFILE command) 3) open the database in NORESETLOGS mode. If you have ONLY LOST the controlfiles after a shutdown abort or hardware crash you have to : 1) startup nomount 2) recreate the controfiles (CREATE CONTROLFILE command) 3) recover database (this will use your online logs) 3) open the database in NORESETLOGS mode. Hope thie helps At 13:15 09/01/2003 -0800, you wrote: >Jeff, > >You are right. It's still possible to create the controlfile by hand using >the CREATE CONTROLFILE .... command. You can do, in fact you *have* to do >incomplete recovery "recover database using backup controlfile until cancel" > >However, a BIG however, here; you MUST know all the file names that were >there in the database, except temporary tablespace, all redo logs to create >the controlfile. It's often this information that's impossible to obtain. >Therefore it's a good practice to throw in a statement "ALTER DATABASE >BACKUP CONTROLFILE TO TRACE" into your regular hot backup script or just a >cronjob that creates the trace file in the user_dump_dest directory. In case >of a disater like this you have at least that file to go back to and save >yourself from writing the commands. > >HTH. > >Arup Nanda > > >----- Original Message ----- >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, January 09, 2003 3:04 PM > > >> >> Wrong...I _think_ :) >> >> If he rebuilds them using the correct file placements then >> it will work. The only problem is that he will have to open >> RESETLOGS and incomplete recovery will be impossible. But >> if he has all of his datafiles and is only missing control >> files then he can startup nomount and create controlfile >> from there. >> >> Jeff Herrick >> non-OCP DBA >> >> On Thu, 9 Jan 2003, David L Phillips wrote: >> >> > No. It would be like getting amnesia and just using the memories of >someone that looks like you. >> > The data stored in the control files is unique to that database. It >contains location of files, database name, recovery info etc. >> > >> > >> > David L Phillips >> > Database Consultant (8i OCP) >> > Digital Concepts Inc. >> > >> > >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Jeff Herrick >> INET: [EMAIL PROTECTED] >> >> Fat City Network Services -- 858-538-5051 http://www.fatcity.com >> San Diego, California -- Mailing list and web hosting services >> --------------------------------------------------------------------- >> To REMOVE yourself from this mailing list, send an E-Mail message >> to: [EMAIL PROTECTED] (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.net >-- >Author: Arup Nanda > INET: [EMAIL PROTECTED] > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com >San Diego, California -- Mailing list and web hosting services >--------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (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). > > > Gilles Parc carpe diem !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gilles PARC INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
