Thanks - useful. I also found:
http://www.dbaoncall.net/references/ht_recover_with_lost_df.html
Stan <stan0074_at_yahoo.com> wrote in message news:<3DBF3984.30208_at_yahoo.com>...
> michela rossi wrote:
>
> >Hi,
> >
> >Somehow we've managed to delete (and lose i.e. not backup) one of our
> >..dbf files. Now, when Oracle starts up on reboot if I try to login
> >using sqlplus I get the error: "ORA-01033: ORACLE initialization or
> >shutdown in progress".
> >
> >So: if I go into "svrmgrl", and "connect internal", "shutdown
> >immediate" (on shutdown immediate I get "ORA-01109: database not
> >open"), "startup" - I then get the message "ORA-01589: must use
> >RESETLOGS or NORESETLOGS option for database open" - what should I do
> >now? Anyone any ideas?
> >
> >Can anyone help?
> >Regards, Michela.
> >
> go to http://www.jlcomp.demon.co.uk/faq/ind_faq.html#Recovery. this
> should help.
Received on Thu Oct 31 2002 - 08:52:47 CST
