Re: deleted undotbs01.dbf...

From: gazzag <gareth_at_jamms.org>
Date: Wed, 01 Aug 2007 03:50:56 -0700
Message-ID: <1185965456.884226.284050@k79g2000hse.googlegroups.com>

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

Operating system? Oracle version?

Anyway, if the database is in ARCHIVELOG mode and you have datafile backups, restore the latest copy of UNDOTBS01.DBF at the operating system level then recover your database.

If you're not in ARCHIVELOG mode, you will have to restore you your last consistent (cold) backup.

HTH -g Received on Wed Aug 01 2007 - 05:50:56 CDT