Re: deleted undotbs01.dbf...

From: <fitzjarrell_at_cox.net>
Date: Wed, 01 Aug 2007 05:40:42 -0700
Message-ID: <1185972042.457744.296400@d30g2000prg.googlegroups.com>

On Aug 1, 5:24 am, de12261 <de12..._at_gmail.com> wrote:
> Hello
>
> I made a mistake and deleted undotbs01.dbf.
>
> now i try to restart the server without success.
> i try to recreate an undo tablespace too, but it is not possible due
> to "database not open" error and if i try to "alter database open" i
> get "ORA-01092: oracle instance terminated. disconnection forced".
>
> Please, HELP!!
>
> thankyou

If you don't have a valid backup, either cold or hot, of this database you really have no other option other than to recreate this database. I hope you have at least a recent export if you don't have a backup. Any port is better than no port in this storm.

David Fitzjarrell Received on Wed Aug 01 2007 - 07:40:42 CDT