Database not open and needs recovery
I have a the Oracle database (10gR2) hooked up to a Learning Management System. Today I received an error for the database that sends me through a loop of errors.
One error is the "ORA-01109: Database not open" error. When I tried the "alter database open;" command, it told me it couldn't because one of my files needed media recovery. Looking at the Enterprise Manager, it is giving me the message "ORA-01033: ORACLE initialization or shutdown in progress." Through the Windows Server 2003 "Services" I restarted all Oracle services and still received the error.
I also tried recovering the file the system is telling me needs recovery. But, then I get the 1109 error telling me the recover failed because the database is not open.
Is there anyway to stop the cycle of errors without just deleting the database and reinstalling it and all the tables?