oracle報錯： ORA-03113: end-of-file on communication channel Process

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 4907

Session ID: 1 Serial number: 5

這種錯誤的解決方案

 出現這個報錯之后，明明oracle已經mount，此時查看oracle的狀態：

 select open_mode from v$database;

 ERROR:

 ORA-03114: not connected to ORACLE

提示oracle就根本沒有連接到oracle

1，此時先查看alert日志

$locate alert_orcl.log（我實例名是orcl）

 /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log

發現alter日志報錯：

ORA-19815: WARNING: db_recovery_file_dest_size of 4039114752 bytes is 100.00% used, and has 0 remaining bytes available.

************************************************************************

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.

************************************************************************

Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_4907.trc:

************************************************************************

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 44462592 bytes disk space from 4039114752 limit

*** 2014-08-24 17:04:51.935 4132 krsh.c

ARCH: Error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2014_08_24/o1_mf_1_117_%u_.arc'

由于db_recovery_file_dest_size定義的閃回空間全部用完了，而導致了oracle無法自動歸檔！！！而且oracle給出了四中解決建議

2，進入閃回空間看看閃回的使用情況

  目錄：/u01/app/oracle/flash_recovery_area/ORCL/archivelog

  發先此時已經無法刪除，只能將由db_recovery_file_dest_size定義的閃回區域（FRA）增大，而且由于db現在提示無法連接到oracle，所有修改spfile是沒有可能的（即是通過alter system set來完成），只能修改pfile，從pfile打開db（pfile是文本文件，直接修改，spfile是二進制文件，只能通過alter system 來完成修改） 

3，修改pfile

 cd /u01/app/oracle/admin/orcl/pfile/

  vi init.ora

  直接改：*.db_recovery_file_dest_size=8039114752

4，然后從pfile啟動數據庫

  startup pfile='/u01/app/oracle/admin/orcl/pfile/init.ora'

  在用pfile從新生成spfile