ORA-03113 解决办法
来源:互联网 发布:知乎日报启动画面 编辑:程序博客网 时间:2024/06/08 06:41
有个数据库,好久没碰了,今天临时需要用一下,发现instance挂了,启动时候报如下错误:
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 27 13:42:46 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn /as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 6747725824 bytesFixed Size 2213976 bytesVariable Size 5234493352 bytesDatabase Buffers 1476395008 bytesRedo Buffers 34623488 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 19925Session ID: 96 Serial number: 3
报了03113错误
[oracle@yoo ~]$ oerr ora 0311303113, 00000, "end-of-file on communication channel"// *Cause: The connection between Client and Server process was broken.// *Action: There was a communication error that requires further investigation.// First, check for network problems and review the SQL*Net setup. // Also, look in the alert.log file for any errors. Finally, test to // see whether the server process is dead and whether a trace file// was generated at failure time.就查了下日志,有如下关键信息:
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 100.00% used, and has 0 remaining bytes available.
<txt>Errors in file /usr/local/oracle/diag/rdbms/hiboxbi/hiboxBI/trace/hiboxBI_arc1_19938.trc:ORA-16038: log 2 sequence# 5651 cannot be archivedORA-19809: limit exceeded for recovery filesORA-00312: online log 2 thread 1: '/usr/local/oracle/oradata/HIBOXBI/onlinelog/o1_mf_2_71qg20vh_.log'ORA-00312: online log 2 thread 1: '/usr/local/oracle/flash_recovery_area/HIBOXBI/onlinelog/o1_mf_2_71qg21kq_.log' </txt></msg><msg time='2013-11-27T13:43:03.116+08:00' org_id='oracle' comp_id='rdbms'很明显了,db_recovery空间满了,解决办法有2个(增加空间大小或者清理过期的归档日志),这里采用了前者,问题解决。
SQL> startup mount;ORACLE instance started.Total System Global Area 6747725824 bytesFixed Size 2213976 bytesVariable Size 5234493352 bytesDatabase Buffers 1476395008 bytesRedo Buffers 34623488 bytesDatabase mounted.SQL> show parameter db_recovery_file_dest_size;NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest_size big integer 3882MSQL> alter system set db_recovery_file_dest_size=8G scope=both;System altered.SQL> start^H^H^H^H^HSP2-0310: unable to open f.sql"SQL> alter database open;Database altered.
---------------------------------------------------------------------------------------------------------------------------------------------------------
版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
QQ: 380968195
Email: 380968195@qq.com
Blog: http://blog.csdn.net/selectdb
- ORA-03113 解决办法
- Oracle ORA-03113错误解决办法
- 【ORA】ORA-16629解决办法
- ORA-00604,ORA-12705解决办法
- ORA-00119,ORA-00132解决办法
- ORA-16014错误解决办法
- ORA-00600 错误解决办法
- Ora-27100错误解决办法
- ORA-20446 错误解决办法
- Ora-03114解决办法
- ORA-16038 的解决办法
- ORA-01653错误解决办法
- ORA-01653错误解决办法
- ORA-12560解决办法
- ORA-16014错误解决办法
- ORA-01653: 解决办法
- ORA-01659解决办法
- ORA-12519:解决办法
- 建筑物的轮廓问题
- 一个PHP程序员应该掌握的10项技能!
- 易信,不改难成大事
- Java 判断字符串是否为空的三种方法
- cacti 画图 断续问题处理
- ORA-03113 解决办法
- sqlserver2008 安装 出现"服务SQLBrowser启动请求失败”
- ubuntu 配置ganlia监控hadoop 单机配置
- struts convension plugin
- 大端小端再总结
- 嵌入式设备使用的web服务器 ——thttpd移植
- android 系统文件路径.sdcard路径.外部路径
- UIScrollView 放大缩小及同时切换图片
- c++ STL序列式容器的共性(权哥)