Message from discussion deleted undotbs01.dbf...

Path: g2news2.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!cleanfeed3-a.proxad.net!nnrp16-1.free.fr!not-for-mail
From: "astalavista" <nob...@nowhere.com>
Newsgroups: comp.databases.oracle.server
References: <1185963894.170142.125930@22g2000hsm.googlegroups.com>
Subject: Re: deleted undotbs01.dbf...
Date: Wed, 1 Aug 2007 14:54:02 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Original
Lines: 13
Message-ID: <46b0825f$0$10110$426a34cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 01 Aug 2007 14:53:52 MEST
NNTP-Posting-Host: 82.243.104.51
X-Trace: 1185972832 news-4.free.fr 10110 82.243.104.51:2213
X-Complaints-To: abuse@proxad.net


> 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".

If you comment UNDO_MANAGEMENT = auto
in your pfile/spfile
can you open the database ?