Re: deleted undotbs01.dbf...

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 02 Aug 2007 17:33:44 -0700
Message-ID: <1186101224.332275.159930@e9g2000prf.googlegroups.com>

On Aug 1, 6: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

Do you have any recent good backups?

If so what utilities were used to create the backups?

Depending on existence of backups you might be able to do a recover until cancel or until a point in time.

Is your database in archivelog mode? Received on Thu Aug 02 2007 - 19:33:44 CDT