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

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

--
http://www.freelists.org/webpage/oracle-l

Other related posts: