Re: lost control files

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" <ORACLE-L_at_fatcity.com>
>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: jherrick_at_igs.net
>>
>> 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: 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.net
>--
>Author: Arup Nanda
> INET: arupnanda_at_hotmail.com
>
>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: 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).
>
>
>

Gilles Parc

carpe diem !!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gilles PARC
  INET: gparc_at_online.fr

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: 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).