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

I'm guessing that somehow your restore has missed an autoextend of the datafile maybe? If you haven't yet done so, I'd make sure you restore all the files from that backup (after you make backups of the datafiles in their current state, just in case--can you have too many backups?:). Hopefully, by now, you've gotten the SEV 1 SR open and are getting guidance from support as well.

Dan

Srinivas Chintamani 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

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