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

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 30 Nov 2006 13:22:39 -0500
Message-ID: <FBEIIHEAOIFCBBNIIFOGCENMCEAA.mwf@rsiz.com>

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:22:39 CST