首页 > 代码库 > 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处理办法