Not Open Database:ORA-03113: end-of-file on communication channel
For
several days the DB can not be opened, only mount
When you try to open it gives me the error: "ORA-03113: end-of-file on communication channel"
I tried to do:
1.-SQL> SHUTDOWN ABORT
2.-SQL> STARTUP MOUNT
3.-SQL> RECOVER DATABASE UNTIL CANCEL
(CANCEL)
CANCEL
ORA-01 547: warning: RECOVER succeeded But OPEN RESETLOGS would get error Below
ORA-01194: file 1 needs more recovery to be Consistent
ORA-01110: data file 1: 'D: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBF'
ORA-01112: media recovery Not started
Modify the parameters in the init.ora:
_allow_resetlogs_corruption = TRUE
undo_management = MANUAL
4.-SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> ALTER DATABASE OPEN RESETLOGS;
When you try to open it gives me the error: "ORA-03113: end-of-file on communication channel"
I tried to do:
1.-SQL> SHUTDOWN ABORT
2.-SQL> STARTUP MOUNT
3.-SQL> RECOVER DATABASE UNTIL CANCEL
(CANCEL)
CANCEL
ORA-01 547: warning: RECOVER succeeded But OPEN RESETLOGS would get error Below
ORA-01194: file 1 needs more recovery to be Consistent
ORA-01110: data file 1: 'D: \ ORACLE \ ORADATA \ ORCL \ SYSTEM01.DBF'
ORA-01112: media recovery Not started
Modify the parameters in the init.ora:
_allow_resetlogs_corruption = TRUE
undo_management = MANUAL
4.-SQL> ALTER DATABASE OPEN RESETLOGS;
SQL> ALTER DATABASE OPEN RESETLOGS;
0