Forum OpenACS Development: Response to Screwed Oracle

Collapse
2: Response to Screwed Oracle (response to 1)
Posted by roland dunn on
Just to expand a little on this. This is more information on where we got to:

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 we do now? Anyone any ideas?