ORA-03113 end-of-file on communication channel

sqlplus /nolog

conn / as sysdba

select status from v$instance;

startup nomount

alter database mount;

alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 2;

alter database clear unarchived logfile group 3;

alter database clear unarchived logfile group 4;

shutdown immediate;

startup;

select status from v$instance;

Leave a Reply

Your email address will not be published.