RE: Recovery from loss of both control files & redo log files
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: "Kevin Lidh" <kevin.lidh@xxxxxxxxx>
- Date: Thu, 30 Nov 2006 13:31:21 -0500
Cool article, thanks for pointing it out.
-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
-----Original Message-----
From: Kevin Lidh [mailto:kevin.lidh@xxxxxxxxx]
Sent: Thursday, November 30, 2006 1:30 PM
To: Bobak, Mark
Cc: oradba.la@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Recovery from loss of both control files & redo log files
I read this article by Howard Rogers and thought it was really good.
Maybe it will be helpful to you since your situation is so similar.
http://www.dizwell.com/prod/node/399
On Thu, 2006-11-30 at 13:13 -0500, Bobak, Mark wrote:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
