Database Backup and Recovery (MOSC)

MOSC Banner

Not Open Database:ORA-03113: end-of-file on communication channel

edited Jul 13, 2010 4:22AM in Database Backup and Recovery (MOSC) 9 commentsAnswered
 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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center