Home > IT Answers > Oracle > How to recover from ORA 01033 Oracle installation or shutdown in progress error
Gianmoor
10 pts.
 How to recover from ORA 01033 Oracle installation or shutdown in progress error
Oracle 8i, Oracle Database, Oracle error messages
After UPS failure my database failed and given ORA-01033 error. I stopped all Oracle services and copied ORA data file to another server, having same database name and SID. The old Oracle was in C Drive and new is in E Drive. I am getting the same error. Can I recover my data anyway. Please help. Also, please tell me in which files I should change the path of database. The database is start up but with ORA-01157 & ORA-01110 errors

Shutdown with error ORA-01081 error...please help immediately.



Software/Hardware used:
Oracle 8i & Windows XP
ASKED: November 26, 2011  2:55 PM
UPDATED: April 19, 2013  2:36 PM
RELATED QUESTIONS
Answer Wiki:
The ORA-01157 error is telling you that Oracle cannot locate and/or access the data files identied by the ORA-01110 error, and Oracle cannot start if it cannot locate/access these data files. And, the ORA-01081 error is telling you that you cannot start an already running or partially started database. I would recommend issuing a "shutdown abort" command to forcefully stop Oracle and clear the instance from memory, then bounce the machine and make sure that all of the data files, redo logs, control files, and parameter file exist and accessible by Oracle and once they are you should be able to start Oracle cleanly.
Last Wiki Answer Submitted:  April 19, 2013  2:36 pm  by  Michael Tidmarsh   13,930 pts.
All Answer Wiki Contributors:  Michael Tidmarsh   13,930 pts. , TechTalker   2,280 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _