Re: deleted undotbs01.dbf...

From: astalavista <nobody_at_nowhere.com>
Date: Wed, 1 Aug 2007 14:54:02 +0200
Message-ID: <46b0825f$0$10110$426a34cc@news.free.fr>

> 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 ? Received on Wed Aug 01 2007 - 07:54:02 CDT

This message: [ Message body ]
Next message: DA Morgan: "Re: obvious bugs with 10.2.0.2 and aix5L"
Previous message: emdproduction_at_hotmail.com: "Re: Recommendations sought for good RAC monitoring tool"
In reply to: de12261: "deleted undotbs01.dbf..."
Next in thread: sybrandb: "Re: deleted undotbs01.dbf..."
Reply: sybrandb: "Re: deleted undotbs01.dbf..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US