ORA-03113: end-of-file on communication channel，filechannel
oracle開啟報錯：
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 29196
Session ID: 1144 Serial number: 7
SQL>
去查看後台alert日誌，資訊顯示如下：
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:
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 to
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
【解決辦法】：
1，可以通過修改過db_recovery_file_dest_size，把其值改大些。
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，刪除到期的歸檔日誌，使用作業系統或RMAN DELETE 命令刪除到期的命令。如果使用作業系統命令刪除檔案，要用rman執行
crosscheck archivelog all;
crosscheck archivelog all;
----------------------------------------------------------------------------------------------------------------
<著作權，文章允許轉載，但必須以連結方式註明源地址，否則追究法律責任!>
原部落格地址：http://blog.csdn.net/mchdba/article/details/45152355
原作者：黃杉 (mchdba)
----------------------------------------------------------------------------------------------------------------
