数据库启动open报错:ORA-03113: end-of-file on communication channel
来源:互联网 发布:泗阳网络问政123456 编辑:程序博客网 时间:2024/06/05 08:35
数据库启动open报错:ORA-03113: end-of-file on communication channel
SQL> startup
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2228904 bytes
Variable Size 314576216 bytes
Database Buffers 92274688 bytes
Redo Buffers 4292608 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2425
Session ID: 1 Serial number: 5
alert 如下:
Errors in file /u01/oracle/diag/rdbms/qing/qing/trace/qing_ora_2716.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 314572800 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.
************************************************************************
ARCH: Error 19809 Creating archive log file to '/u01/flashback/QING/archivelog/2013_09_16/o1_mf_1_21_%u_.arc'
Errors in file /u01/oracle/diag/rdbms/qing/qing/trace/qing_ora_2716.trc:
ORA-16038: log 5 sequence# 21 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 5 thread 1: '/u01/oracle/oradata/qing/redo05.log'
USER (ospid: 2716): terminating the instance due to error 16038
System state dump requested by (instance=1, osid=2716), summary=[abnormal instance termination].
System State dumped to trace file /u01/oracle/diag/rdbms/qing/qing/trace/qing_diag_2664.trc
Dumping diagnostic data in directory=[cdmp_20130916033718], requested by (instance=1, osid=2716), summary=[abnormal instance termination].
Instance terminated by USER, pid = 2716
解决办法 :
SQL> startup mount
[oracle@OEL63 ~]$ rman target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;
SQL> alter database open;
- 数据库启动open报错:ORA-03113: end-of-file on communication channel
- rac数据库的服务无法启动,报错ORA-03113: end-of-file on communication channel
- Oracle--oracle实例启动报ORA-03113: end-of-file on communication channel
- RAC 实例不能启动 手工启动实例报错 ORA-03113 end-of-file on communication channel
- 使用dgmgrl 切换报错 ORA-03113: end-of-file on communication channel
- SQL报错:ORA-03113: end-of-file on communication channel-3113
- ORA-03113: end-of-file on communication channel 报错解决方法之一
- ORA-03113: end-of-file on communication channel 报错的问题
- 打开oracle报错:ora-03113:end-of-file on communication channel
- hibernate集合查询报错:ora-03113:end-of-file on communication channel
- ORA-03113: end-of-file on communication channel ORA-00257: archiver error. Connect 归档日志满导致数据库没有办法启动
- PRCR-1079 : 无法启动资源 ora.orcl.db ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- ORA-03113: end-of-file on communication channel
- 遇到ORA-03113: end-of-file on communication channel
- 后缀树的构造方法-Ukkonen详解
- 【1】Golismero插件编写-UI插件编写
- Linux工具安装---MySQL
- WPF
- office 文档解析
- 数据库启动open报错:ORA-03113: end-of-file on communication channel
- 正则表达式30分钟入门教程(用心看,包学会)
- 黑马程序员-面向对象思想
- 位运算符和逻辑运算符
- Android Toast 设置到屏幕中间,自定义Toast的实现方法,及其说明
- TODO:view的getwidth(), getHeight()什么时候会有值
- linux下c语言嵌入汇编
- MongoDB分页处理方案
- 链表实现一元多项式创建的另两种做法