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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manjula Krishnan Sent: Thursday, November 30, 2006 1:05 PM To: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 30 2006 - 12:13:16 CST