Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close