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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 22 Apr 2008 23:21:03 +0800
Message-Id: <200804221521.m3MFLgWF015901@smtp17.singnet.com.sg>

If you lose an active Undo Tablespace, the presence of another Undo Tablespace doesn't help because
Instance Recovery still has to access the [lost] Undo Tablespace before 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 create
>two Undo tablespaces. That way if you lose your primary, you just
>have 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
Received on Tue Apr 22 2008 - 10:21:03 CDT

Original text of this message