How to fix ORA-03113: end-of-file on communication channel Process ID: 194555 Session ID: 1537 Serial number: 3

How to fix Oracle

ORA-03113: end-of-file on communication channel Process ID: 194555 Session ID: 1537 Serial number: 3

ERROR: failed to establish dependency between database TEDAS and diskgroup resource ora.DATAC1.dg

SQL> shu immediate;

SQL> alter database nomount;

SQL> alter database mount;

SQL> select * from v$log;

SQL> alter database clear unarchived logfile group 50;

SQL> alter database clear unarchived logfile group 51;

Database altered.

SQL> alter database open
2
SQL> alter database open;

Database altered.

SQL> select status from v$instance;

STATUS

OPEN

Comments

zahi
Great dear,
Reply · 1 month ago

Abbas
ORA-01190: control file or data file 3 is from before the last RESETLOGS
Reply · 1 month ago

Tom
Thanks alot. it worked for me
Reply · 2 weeks ago