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

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