Oracle錯誤——ORA-03113:通訊通道的檔案結尾 解決辦法

Oracle錯誤——ORA-03113:通訊通道的檔案結尾 解決辦法

由來

今天跟往常一樣，登陸PL/SQL，確登陸失敗，出現一個錯誤“ORA-01034”和“ORA-27101”

然後就就通過命令提示字元去登陸Oracle，去查看怎麼回事，然後問題進一步出現，錯誤“ORA-03113:通訊通道的檔案結尾 進程 ID:6320 回話 ID :191 序號：3”。

問題根源

Oracle出現錯誤，於是去錯誤記錄檔裡去找問題根源：在 e:\app\kang\diag\rdbms\oracle\oracle\trace\檔案夾下找到oracle_ora_6320.trc檔案，開啟顯示錯誤記錄檔：

Trace filee:\app\kang\diag\rdbms\oracle\oracle\trace\oracle_ora_6320.trc
Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit Production
With thePartitioning, OLAP, Data Mining and Real Application Testing options
Windows NT VersionV6.1 Service Pack 1
CPU                : 4 - type 8664, 2 PhysicalCores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total):Ph:2805M/6087M, Ph+PgF:6761M/12173M
Instance name: oracle
Redo thread mountedby this instance: 1
Oracle processnumber: 19
Windows thread id:6320, image: ORACLE.EXE (SHAD)
 
 
*** 2014-08-1608:18:55.461
*** SESSIONID:(191.3) 2014-08-16 08:18:55.461
*** CLIENT ID:()2014-08-16 08:18:55.461
*** SERVICE NAME:()2014-08-16 08:18:55.461
*** MODULENAME:(sqlplus.exe) 2014-08-16 08:18:55.461
*** ACTION NAME:()2014-08-16 08:18:55.461
 
ORA-19815: 警告:db_recovery_file_dest_size 位元組 (共 4102029312 位元組) 已使用 100.00%, 尚有 0 位元組可用。
************************************************************************
You have followingchoices to free up space from recovery area:
1. Consider changingRMAN RETENTION POLICY. If you are using Data Guard,
  then consider changing RMAN ARCHIVELOGDELETION POLICY.
2. Back up files totertiary device such as tape using RMAN
  BACKUP RECOVERY AREA command.
3. Add disk space andincrease db_recovery_file_dest_size parameter to
  reflect the new space.
4. Delete unnecessaryfiles using RMAN DELETE command. If an operating
  system command was used to delete files,then use RMAN CROSSCHECK and
  DELETE EXPIRED commands.
************************************************************************
ORA-19809:超出了恢複檔案數的限制
ORA-19804: 無法回收33961984 位元組磁碟空間 (從 4102029312 限制中)
*** 2014-08-1608:18:55.502 4132 krsh.c
ARCH: Error 19809Creating archive log file to'E:\APP\KANG\FLASH_RECOVERY_AREA\ORACLE\ARCHIVELOG\2014_08_16\O1_MF_1_159_%U_.ARC'
*** 2014-08-1608:18:55.502 2747 krsi.c
krsi_dst_fail: dest:1err:19809 force:0 blast:1
DDE: Problem Key 'ORA312' was flood controlled (0x1) (no incident)
ORA-00312: 聯機日誌 3 線程1: 'E:\APP\KANG\ORADATA\ORACLE\REDO03.LOG'
ORA-16038: 日誌 3sequence# 159 無法歸檔
ORA-19809:超出了恢複檔案數的限制
ORA-00312: 聯機日誌 3 線程1: 'E:\APP\KANG\ORADATA\ORACLE\REDO03.LOG'
 
*** 2014-08-1608:18:55.565
USER (ospid: 6320):terminating the instance due to error 16038

從這裡我們發現了問題的根源：“

ORA-19815: 警告: db_recovery_file_dest_size 位元組 (共 4102029312 位元組) 已使用100.00%, 尚有 0 位元組可用。” 是db_recovery_file_dest_size也叫歸檔日誌空間不足導致的，既然找到問題的根源，那解決起來也就容易了。

更多詳情見請繼續閱讀下一頁的精彩內容：

1 2 下一頁