Oracle啟動報錯：ORA-03113: end-of-file on communication channel

Oracle啟動報錯：ORA-03113: end-of-file on communication channel

問題背景：客戶啟動測試環境資料庫報錯

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size     2220200 bytes

Variable Size   885002072 bytes

Database Buffers   176160768 bytes

Redo Buffers     5554176 bytes

Database mounted.

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

Process ID: 17509

Session ID: 416 Serial number: 3

1> 檢視alert日誌

ARC3 started with pid=23, OS id=17541 

ARC2: Archival started

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no SRL' ARCH

ARC2: Becoming the heartbeat ARCH

Errors in file /u01/app/oracle/diag/rdbms/ecology/ecology/trace/ecology_ora_17509.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 53687091200 bytes is 99.99% used, and has 3795456 remaining bytes available.    ---歸檔目錄以及100%

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

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/ecology/ecology/trace/ecology_ora_17509.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 40733696 bytes disk space from 53687091200 limit

ARCH: Error 19809 Creating archive log file to '/u01/app/oracle/flash_recovery_area/ECOLOGY/archivelog/2019_10_22/o1_mf_1_10288_%u_.arc'

Errors in file /u01/app/oracle/diag/rdbms/ecology/ecology/trace/ecology_ora_17509.trc:

ORA-16038: log 1 sequence# 10288 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/ecology/redo01.log'

USER (ospid: 17509): terminating the instance due to error 16038

Instance terminated by USER, pid = 17509

2> 從alert日誌看出歸檔目錄已經滿了，需要清理歸檔目錄

SQL> shutdown immediate

SQL> startup  mount

rman target /

crosscheck archivelog all;

delete archivelog until time 'sysdate -3';--刪除三天前的日誌

重新啟動Oracle成功，，

ps:不建議客戶使用預設歸檔目錄，可以調整為本地目錄並配置定期刪除指令碼

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/69950231/viewspace-2660980/，如需轉載，請註明出處，否則將追究法律責任。