RE: Recovery from loss of both control files & redo log files

Existence of controlfile (and the controlfile trace) isn not really necessary for recovery.. all the info required for recovery (dbid, checkpoint_change#, resetlogs_change#) is available in datafile headers.  

During create controlfile, Oracle goes through the datafile headers and looks what file is what, their order presented in create controlfile statement doesn't matter.  

All you need to know is where your datafiles are and that shouldn't be a problem...  

Tanel.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Miranda
Sent: Friday, December 01, 2006 03:19
To: oradba.la_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Recovery from loss of both control files & redo log files  

First: do a backup of everything  

--
http://www.freelists.org/webpage/oracle-l