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

Although you don't HAVE to have the controlfile (or trace thereof), when you manually
craft the CREATE CONTROLFILE statement, you might make the mistake of missing one
or more datafiles out of the controlfile. In that case, Oracle will still recover the database
but without those datafiles.
(because rollforward recovery from archivelogs is *physical* recovery not *logical* recovery)
If and when you open the database (resetlogs), Oracle will make those "mssing" files
$ORACLE_HOME/dbs/MISSING !

Hemant

At 12:17 AM Saturday, you wrote:
>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.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

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