Cause: Archive log location are full.
SQL> startup;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1342178896 bytes
Database Buffers 788529152 bytes
Redo Buffers 5001216 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3952
Session ID: 127 Serial number: 3
SQL>
From Alert Log
ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file d:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_3952.trc:
ORA-16038: log 1 sequence# 1420 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\APP\ORADATA\ORCL\REDO_01.LOG'
USER (ospid: 3952): terminating the instance due to error 16038
Instance terminated by USER, pid = 3952
Solution:
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1342178896 bytes
Database Buffers 788529152 bytes
Redo Buffers 5001216 bytes
Database mounted.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=400G scope=both;
System altered.
SQL> alter database open;
Database altered.
SQL>
SQL> startup;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1342178896 bytes
Database Buffers 788529152 bytes
Redo Buffers 5001216 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3952
Session ID: 127 Serial number: 3
SQL>
From Alert Log
ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file d:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_3952.trc:
ORA-16038: log 1 sequence# 1420 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\APP\ORADATA\ORCL\REDO_01.LOG'
USER (ospid: 3952): terminating the instance due to error 16038
Instance terminated by USER, pid = 3952
Solution:
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2137886720 bytes
Fixed Size 2177456 bytes
Variable Size 1342178896 bytes
Database Buffers 788529152 bytes
Redo Buffers 5001216 bytes
Database mounted.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=400G scope=both;
System altered.
SQL> alter database open;
Database altered.
SQL>