Re: lost control files

Umm I'll have to apologize for thinking too quick and letting my inner child do the typing.
I haven't had to do a manual create of a control file yet (and hope not to). My paranoia would not allow me to not have a backup control file and init.ora file etc around.
If you have multiple instances of the data base (dev, test, prod) which is what your alluding to, then you would probably have a good start. At this point, I'll bow to the experts here and drag my humble carcass back over to the "just ask questions" side of the room for a while.

David L Phillips
Database Consultant (8i OCP)
Digital Concepts Inc.

> > But if u look at the control file dump script . It doesn't say anything
about creation date or scn or anything . All it has is list of datafiles , logfiles .. etc. > > If my other db on another server is layed out exactly same . wny can't I use that control file , just change db name .
> > -Bp
> >

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 09, 2003 2:19 PM

> > BigP wrote:
> >
> >
> >
> >
> > If I loose all my control files can I restore them by using create
> > control file dump from a similer database .
> >
> >
> >
>
> IMHO it is safer to do a manual 'create control file'. Similarity is
> always just up to a point and gives you a false sense of security. And
> BTW if you lose all of your control files it is quite likely that you
> lose other files as well, and it is not obvious at all that you can
> restart your database, if this was the primarily aim of your question.
> One of the reasons why, when you backup, it is better to backup
> everything (init.ora included), even if 'normally' everything is not
> required to restore. Just in case.
>
> --
> Regards,
>
> Stephane Faroult
> Oriole Software
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephane Faroult
> INET: sfaroult_at_oriole.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David L Phillips
  INET: dphillip_at_dci-usa.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).