ORA-03113: end-of-file on communication channel, filechannel
Oracle open error:
SQL> alter database open
2;
Alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 29196
The Session ID is 1144 Serial number: 7.
SQL>
View the background alert Log. The information is shown as follows:
Errors in file/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_26567.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 512 bytes disk space from 16106127360 limit
ARCH: Error 19809 Creating archive log file to '/oracle/app/oracle/flash_recovery_area/PDUNQ/archivelog/2015_04_19/o1_mf_1_1 _ % u _. arc'
Errors in file/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_26567.trc:
The ORA-16038: log 1 sequence #1 cannot be archived
ORA-12170: TNS: Connect timeout occurred
ORA-00312: online log 1 thread 1: '/home/oradata/powerdes/redo01.log'
Errors in file/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_arc3_27693.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 16106127360 bytes is 100.00% used, and has 0 remaining bytes available.
**************************************** ********************************
USER (ospid: 26567): terminating the instance due to error 16038
You have following choices to free up space from recovery area:
1. Consider changing rman retention policy. If you are using Data Guard,
Then consider changing rman archivelog deletion policy.
2. Back up files to tertiary device such as tape using RMAN
Backup recovery area command.
3. Add disk space and increase db_recovery_file_dest_size parameter
Reflect the new space.
4. Delete unnecessary files using rman delete command. If an operating
System command was used to delete files, then use rman crosscheck and
Delete expired commands.
**************************************** ********************************
Instance terminated by USER, pid = 26567
[Solution ]:
1. You can change the value of db_recovery_file_dest_size to a greater value.
Alter system set db_recovery_file_dest_size = 20G scope = spfile;
SQL> startup mount
ORACLE instance started.
Total System Global Area 3373858816 bytes
Fixed Size 2218032 bytes
Variable Size 1862272976 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16195584 bytes
Database mounted.
SQL> alter system set db_recovery_file_dest_size = 20G scope = spfile;
System altered.
SQL>
SQL> alter database open
2;
Database altered.
SQL>
2. DELETE expired archived logs and use the operating system or rman delete command to DELETE expired logs. If you use an operating system command to delete a file, run rman.
Crosscheck archivelog all;
Crosscheck archivelog all;
Bytes ----------------------------------------------------------------------------------------------------------------
<All Rights Reserved. This document can be reprinted, but the source address must be indicated by link. Otherwise, we will be held legally responsible.>
Original blog address: http://blog.csdn.net/mchdba/article/details/45152355
Original Author: Huang Shan (mchdba)
Bytes ----------------------------------------------------------------------------------------------------------------