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

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

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