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

Since the database was closed at the time, you don't need the redo logs.
(Just open w/ resetlogs.)
 
However, the controlfiles are a bit more problematic.  If you have the
create controlfile command from when the database was created, and you
know about *ALL* datafiles that were added and any tablespaces that were
dropped in the meantime, you ought to be able to cobble together a
representative create controlfile command that you could use to
re-create the controlfile.  If you're successful there, do startup
mount, then alter database open resetlogs.
 
Good luck....
 
 
Hope that helps,
 
-Mark
 

--

Mark J. Bobak

Senior Oracle Architect

ProQuest Information & Learning

There is nothing so useless as doing efficiently that which shouldn't be
done at all.  -Peter F. Drucker, 1909-2005

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manjula Krishnan
Sent: Thursday, November 30, 2006 1:05 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Recovery from loss of both control files & redo log files


We had a disk crash. All data files are intact (database was closed at
the time). But, all redo log files and controlfiles are lost. Can this
database be recovered? This is a development database so I am not too
worried, but would like to know if this is possible. 
 
Thanks,
 
Manjula

Other related posts: