ORA-03113 Error while opening the database

Question

I am trying to restore a database. The job was hung do to some issue, so I have restarted the Oracle service (Windows). I'm now getting an error while connecting to DB:

ORA-03113 end-of-file on communication channel
Process ID :9716
Session ID: 237 serial number :5

How can I solve this error?

Answer 1

ORA-03113 is a generic error. Please read this excellent post here for some information as to the root cause analysis of this error.

As a workaround for your case, assuming you can afford to reset the logs, you can probably do an incomplete database recovery and then open the database with RESETLOGS option:

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;

SQL> ALTER DATABASE RECOVER CANCEL;

SQL> ALTER DATABASE OPEN RESETLOGS;

Answer 2

try this

SQL> STARTUP MOUNT;

SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;

SQL> ALTER DATABASE OPEN RESETLOGS;