How to recover from ORA 01033 Oracle installation or shutdown in progress error

10 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following