Re: lost control files

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