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;".