RE: Recovery from loss of both control files & redo log files
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <mwf@xxxxxxxx>, <Mark.Bobak@xxxxxxxxxxxxxxx>, <oradba.la@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Nov 2006 13:33:58 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mark W. Farnham
Sent: Thursday, November 30, 2006 1:23 PM
To: Mark.Bobak@xxxxxxxxxxxxxxx; oradba.la@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Bobak, Mark
Sent: Thursday, November 30, 2006 1:13 PM
To: oradba.la@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@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:
