Re: deleted undotbs01.dbf...

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 01 Aug 2007 17:28:48 -0400
Message-ID: <qhu1b35cdr2pmst7gu11u1cs58sh047lpp@4ax.com>

On Wed, 01 Aug 2007 03:24:54 -0700, de12261 <de12261_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!!
>

Open a metalink SR, and hope you get an engineer that has a clue. With some help, you might be able to bring up the db and imp/exp your data elsewhere.
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Wed Aug 01 2007 - 16:28:48 CDT