Re: <URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>

From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
To: andrew.kerber@xxxxxxxxx
Date: Tue, 22 Apr 2008 23:21:03 +0800

If you lose an active Undo Tablespace, the presence of another UndoTablespace doesn't help becauseInstance Recovery still has to access the [lost] Undo Tablespacebefore the database can be opened.




At 09:28 PM Tuesday, Andrew Kerber wrote:

I have found that one precaution to always take is to always createtwo Undo tablespaces. That way if you lose your primary, you justhave to switch over to the secondary. It doesnt even have to be very big.
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'



Hemant K Chitale
http://hemantoracledba.blogspot.com

"A 'No' uttered from the deepest conviction is better than a 'Yes'merely uttered to please, or worse, to avoid trouble."Mohandas Gandhi Quotes: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html


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

References:

<URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>
From: Srinivas Chintamani

Re: <URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>
From: Andrew Kerber

Re: <URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>

Other related posts: