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_at_gmail.com]
Sent: Thursday, November 30, 2006 1:30 PM
To: Bobak, Mark
Cc: oradba.la_at_gmail.com; oracle-l_at_freelists.org
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_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:31:21 CST
