首页 > 代码库 > Oracle错误ORA-03113: end-of-file on communication channel处理办法
Oracle错误ORA-03113: end-of-file on communication channel处理办法
oracle不能启动了,报错ORA-03113: end-of-file on communication channel (通信通道的文件结尾)
解决办法:
SQL> startupORACLE instance started. Total System Global Area 1252663296 bytesFixed Size 2227944 bytesVariable Size 704643352 bytesDatabase Buffers 536870912 bytesRedo Buffers 8921088 bytesDatabase mounted.ORA-03113: end-of-file on communication channelProcess ID: 8117Session ID: 191 Serial number: 3网上分析,可能由于昨晚数据库强制关闭,导致文件状态可能不一致,因为正常关闭数据库会同步校验各文件,使得重新启动的时候文件时间点一致。解决方案如下启动DBSQL> conn / as sysdbaConnected to an idle instance. SQL> startup mountORACLE instance started.SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC---------- ---------- ---------- ---------- ---------- ---------- ---STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME---------------- ------------- --------- ------------ --------- 1 1 112 52428800 512 1 NOINACTIVE 3826382 16-JUL-16 3857158 17-JUL-16 3 1 114 52428800 512 1 NOCURRENT 3886899 17-JUL-16 2.8147E+14 2 1 113 52428800 512 1 NOINACTIVE 3857158 17-JUL-16 3886899 17-JUL-16 SQL> alter database open resetlogs 2;alter database open resetlogs 2 *ERROR at line 1:ORA-02288: invalid OPEN mode恢复数据库SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01139: RESETLOGS option only valid after an incomplete database recovery SQL> recover database until time ‘2016-08-05‘Media recovery complete.SQL> alter database open resetlogs; Database altered.成功。
Oracle错误ORA-03113: end-of-file on communication channel处理办法
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。