Thursday, September 29, 2016

ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files)

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>

No comments:

Post a Comment