ORA-03113:通信通道的文件结尾 因为 db_recovery_file_dest_size设置小 导致联机日志不能归档 Oracle不能起来

今天碰到的问题，已经解决

Step 01 , 去错误日志里(trace)去找问题根源,发现问题如下：

************************************************************************
Errors in file e:\app\administrator\diag\rdbms\eswh\eswh\trace\eswh_arc3_5076.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 42084864 字节磁盘空间 (从 4102029312 限制中)
ARC3: Error 19809 Creating archive log file to 'E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ESWH\ARCHIVELOG\2016_03_23\O1_MF_1_92_%U_.ARC'
Errors in file e:\app\administrator\diag\rdbms\eswh\eswh\trace\eswh_ora_5720.trc:
ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 4102029312 字节) 已使用 100.00%, 尚有 0 字节可用。
************************************************************************
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.
************************************************************************

step02 STARTUP MOUNT 启动oracle 服务（mount 只打开控制文件）

Step03 alter system set db_recovery_file_dest_size=8G scope=spfile;

Step04 startup open (启动成功)

Step05 删除过期的归档文件

    rman 

    connect target / 

    delete expired archivelog all;