ora-03113: end-of-file on communication channel
1. 当启动oracle 发现报错
sql> startup
报错：
ora-03113: end-of-file on communication channel
查看alert.log文件，发现
ora-03113: end-of-file on communication channel
cannot reclaim 45680128 bytes disk space from 2147483648 limit
arch: error 19809 creating archive log file to '/u01/flash_recovery_area/orcl/archivelog/2014_01_17/o1_mf_1_6_%u_.arc'
这是由于归档表空间已满，分配不到空间所致
解决办法如下：打开数据库至mount模式，而后删除需要废弃的文件：
rman> startup nomount;
oracle instance started
total system global area 835104768 bytes
fixed size 2217952 bytes
variable size 587204640 bytes
database buffers 243269632 bytes
redo buffers 2412544 bytes
rman> resotre spfile from autobackup;
rman-00571: ===========================================================
rman-00569: =============== error message stack follows ===============
rman-00571: ===========================================================
rman-00558: error encountered while parsing input commands
rman-01009: syntax error: found identifier: expecting one of: advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {,
rman-01008: the bad identifier was: resotre
rman-01007: at line 1 column 1 file: standard input
rman> alter database mount;
database mounted
rman> delete obsolete;
rman retention policy will be applied to the command
rman retention policy is set to recovery window of 1 days
allocated channel: ora_disk_1
channel ora_disk_1: sid=19 device type=disk
deleting the following obsolete backups and copies:
type key completion time filename/handle
-------------------- ------ ------------------ --------------------
backup set 2 27-dec-13
backup piece 2 27-dec-13 /u01/flash_recovery_area/orcl/backupset/2013_12_27/o1_mf_nnndf_tag20131227t172528_9cwb48k0_.bkp
archive log 2 27-dec-13 /u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arc
backup set 1 27-dec-13
backup piece 1 27-dec-13 /u01/flash_recovery_area/orcl/backupset/2013_12_27/o1_mf_ncsnf_tag20131227t172528_9cwb7lrp_.bkp
archive log 1 27-dec-13 /u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arc
archive log 3 27-dec-13 /u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arc
do you really want to delete the above objects (enter yes or no)? yes
deleted backup piece
backup piece handle=/u01/flash_recovery_area/orcl/backupset/2013_12_27/o1_mf_nnndf_tag20131227t172528_9cwb48k0_.bkp recid=2 stamp=835306248
deleted archived log
archived log file name=/u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_7_9cwq8sbj_.arc recid=2 stamp=835306247
deleted backup piece
backup piece handle=/u01/flash_recovery_area/orcl/backupset/2013_12_27/o1_mf_ncsnf_tag20131227t172528_9cwb7lrp_.bkp recid=1 stamp=835306248
deleted archived log
archived log file name=/u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_6_9cwq0xm1_.arc recid=1 stamp=835306247
deleted archived log
archived log file name=/u01/flash_recovery_area/orcl/archivelog/2013_12_27/o1_mf_1_5_9cwm7cv6_.arc recid=3 stamp=835306247
deleted 5 objects
rman> alter datatbase open;
推荐阅读：
ora-01172、ora-01151错误处理
ora-00600 [2662]错误解决
ora-01078 和 lrm-00109 报错解决方法
ora-00471 处理方法笔记
ora-00314,redolog 损坏，或丢失处理方法
ora-00257 归档日志过大导致无法存储的解决办法
，