Originally posted by ngwh
but I am not too sure if a Recover database will know when to start looking for an archived log as I dont have a spare machine to test and was hoping some kind soul that know will provide me an answer here?
thks
"If all control files of a database have been lost or damaged by a permanent media failure, but all online redo logfiles remain intact, then you can recover the database by creating a new control file."
http://download-west.oracle.com/docs...scen.htm#11848
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"