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