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 （通信通道的文件结尾）

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

SQL> startup ORACLE instance started.    Total System Global Area 1252663296 bytes Fixed Size 2227944 bytes Variable Size 704643352 bytes Database Buffers 536870912 bytes Redo Buffers 8921088 bytes Database mounted. ORA-03113: end - of -file on communication channel Process ID: 8117 Session ID: 191 Serial number: 3 网上分析，可能由于昨晚数据库强制关闭，导致文件状态可能不一致，因为正常关闭数据库会同步校验各文件，使得重新启动的时候文件时间点一致。解决方案如下 启动DB SQL> conn / as sysdba Connected to an idle instance.    SQL> startup mount ORACLE instance started. 直接reset不成功 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 NO INACTIVE 3826382 16-JUL-13 3857158 17-JUL-13              3 1 114 52428800 512 1 NO CURRENT 3886899 17-JUL-13 2.8147E+14              2 1 113 52428800 512 1 NO INACTIVE 3857158 17-JUL-13 3886899 17-JUL-13       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 '2013-07-05' Media recovery complete. SQL> alter database open resetlogs;    Database altered. 成功。