Re: Damaged Undo Tablespace

Additional Info:

I can start and mount the database, but when I try to open it, I get an error that says that the UNDO TABLESPACE can not be opened, and then the whole database closes. I tried setting the UNDO mode to manual figuring that then it should not need the undo tablespace, but the same thing occurs...no way to get the the database open.

I would appreciate any help!!! My next step is pretty drastic (new database, re-import from very old data and re-update the data)...please help me to avoid that.

Thanks

"Schrödinger's Cat" <72446.2772_at_compuserve.com> wrote in message news:kOk59.1485$WW3.436120635_at_twister2.starband.net...
> We had a power failure during database (9i) operation. All the data
> tablespaces seem to be fine, but the database will not start because the
> undo tablespace is corrupt. There is nothing I need to worry about losing
> in the Undo space. I do not have a backup of the database in 9i. I have
> tried dropping the undo tablespace, removing it, etc. Nothing will allow
> the thing to come back online. I am not the most experience Oracle guy,
so
> there is probably something obvious...would someone tell me what that
> obvious thing is? What do I do to get this database back? Thanks.
>
> Lost in outer<table>space
>
>
Received on Sun Aug 11 2002 - 11:58:28 CDT