<URGENT> How do I recover when the UNDO tablespace data file is corrupt? </URGENT>
- From: "Srinivas Chintamani" <srinivas.chintamani@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 21 Apr 2008 18:46:23 +0530
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
Other related posts: