On Aug 1, 2:54 pm, "astalavista" <nob..._at_nowhere.com> wrote:
> > 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 ?
The tablespace and datafile info is still in the controlfile.
Is not going to work.
--
Sybrand Bakker
Senior Oracle DBA
Received on Wed Aug 01 2007 - 08:36:05 CDT
