ORA-01113 and ORA-01110 errors on restarting database
I experienced an error(ORA-01033) that was posted here before. I follwed the instructions that were in the posting:
sqlplus /nolog
shutdown abort
startup
But after I started it up there were errors. I got ORA-01113 and ORA-01110 stating that the file needs media recovery. Please help.
The ORA-1113 error is telling you that you need to apply recovery to the database. The ORA-1110 message is telling you which file needs recovery. Since the database was up and running, and you just did a SHUTDOWN ABORT, all you should need to do is force Oracle to apply recovery. Instead of STARTUP, issue "STARTUP MOUNT" followed by "RECOVER DATABASE;". Once recovery is complete, issue "ALTER DATABASE OPEN;".
Dig Deeper on Oracle error messages
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments