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

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.

On Mon, Apr 21, 2008 at 8:16 AM, Srinivas Chintamani < srinivas.chintamani_at_gmail.com> wrote:

> Hi All,
>
> I am getting the following errors when I am trying to open my database.
> There was a power failure to the server over the weekend, that caused me all
> of this messs.
>
> Here are the errrors:
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - -
> ORA-01122: database file 2 failed verification check
> ORA-01110: data file 2: 'C:\ORACLE\ORADATA\TRACS3\UNDOTBS01.DBF'
> ORA-01200: actual file size of 83976 is smaller than correct size of
> 138240 blocks
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> - - - - -
>
> Does anybody have any ideas on how to get my db started back? The last
> known good back up is about a month-and-a-half old. All other datafiles
> seem to be ok.
>
> I would really appreciate any help on getting my database up.
>
> --
> Regards,
> Srinivas Chintamani

-- 
Andrew W. Kerber

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

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