Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: lost control files

Re: lost control files

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Thu, 09 Jan 2003 11:19:13 -0800
Message-ID: <F001.0052B8AE.20030109111913@fatcity.com>


> 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).
Received on Thu Jan 09 2003 - 13:19:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US