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:不建议客户使用默认归档目录,可以调整为本地目录并配置定期删除脚本
Oracle启动报错:ORA-03113: end-of-file on communication channel
来源:这里教程网
时间:2026-03-03 14:21:50
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- 【练习】RAC数据库常用命令
【练习】RAC数据库常用命令
26-03-03 - Oracle RAC CacheFusion 系列十六:Oracle RAC CurrentBlock Server
- iPhone通话中不能录音,却能充当"窃听器",你不会现在才知道吧
iPhone通话中不能录音,却能充当"窃听器",你不会现在才知道吧
26-03-03 - 基于advisor优化工具的一次sql优化
基于advisor优化工具的一次sql优化
26-03-03 - MaxCompute问答整理之9月
MaxCompute问答整理之9月
26-03-03 - instance crash after ORA-7445 [opiaba] and ORA-600 [17147] (文档 ID 1466343.1)
- 三个关键词,解读美团点评“ Food+X”场景营销优势
三个关键词,解读美团点评“ Food+X”场景营销优势
26-03-03 - 纯干货!越早关闭苹果这3个"偷电"大户,不用一年换一个电池
纯干货!越早关闭苹果这3个"偷电"大户,不用一年换一个电池
26-03-03 - 携程的 Dubbo 之路
携程的 Dubbo 之路
26-03-03 - 国家扶贫日交答卷,社交电商扣开扶贫新大门
国家扶贫日交答卷,社交电商扣开扶贫新大门
26-03-03
