RE: Recovery from loss of both control files & redo log files
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: tanel.poder.003@xxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 04 Dec 2006 23:38:25 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
