1 Reply Latest reply on Nov 20, 2017 8:49 AM by Elvin Shikhalizada

    ORA-03113: end-of-file on communication channel

    Pasika

      I add the new redo log group with redolog04,05,06 files. Then i specially delete from OS redo01.log, redo02.log and redo03.log. After restart, the database did not start anymore, showing ORA-03113 error.

        • 1. Re: ORA-03113: end-of-file on communication channel
          Elvin Shikhalizada

          You must  clear unarchived logfiles.

           

           

          For example:

          SQL> startup nomount

          ORACLE instance started.

           

          Total System Global Area 2147483648 bytes

          Fixed Size 2926472 bytes

          Variable Size 1224738936 bytes

          Database Buffers 905969664 bytes

          Redo Buffers 13848576 bytes

          SQL> alter database mount;

           

          Database altered.

           

          SQL> alter database clear unarchived logfile group 1;

          Database altered.

           

          SQL> alter database clear unarchived logfile group 2;

          Database altered.

           

          SQL> alter database clear unarchived logfile group 3;

          Database altered.

          1 person found this helpful