RE: Recovery from loss of both control files & redo log files
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oradba.la@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Nov 2006 13:13:16 -0500
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:
