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

標籤：ora-03113 end-of-file

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

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