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

Do you backup your control file to trace. If so just pull it from your udump directory and use it to recreate a control file. Since all the datafiles are intact you know all the paths to the files, you can backup your test or prod database to trace and edit that file to recreate the controlfile. This assumes a clean shutdown as the others have responded.  

Ken  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Thursday, November 30, 2006 1:23 PM To: Mark.Bobak_at_il.proquest.com; oradba.la_at_gmail.com; oracle-l_at_freelists.org Subject: RE: Recovery from loss of both control files & redo log files  

Mark is presuming your last shutdown was a shutdown normal for this scenario to work. Otherwise lost data from the redo logs could indeed be required. If you got lucky on checkpoint timing so all active transactions have been written through the last commit, you might even get lucky in that case. Worth a try at least.  

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Bobak, Mark
Sent: Thursday, November 30, 2006 1:13 PM To: oradba.la_at_gmail.com; oracle-l_at_freelists.org Subject: 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:33:58 CST