Re: <URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>
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-lReceived on Tue Apr 22 2008 - 10:21:03 CDT