ORA-03113: end-of-file on communication channel （通信通道的文件结尾）Oracle数据库启动异常

机器遭遇断电，之后oracle就不能启动了，报错ORA-03113: end-of-file on communication channel （通信通道的文件结尾）

1. 首先，打开命令行cmd：
   C:\Documents and Settings\Administrator>sqlplus system/123456
   
   SQL*Plus: Release 11.2.0.1.0 Production on 星期一 11月 11 11:31:13 2013
   
   Copyright (c) 1982, 2010, Oracle.  All rights reserved.
   
   
   连接到:
   Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
   With the Partitioning, OLAP, Data Mining and Real Application Testing options
   
   SQL> conn /as sysdba
   已连接。
   
2. 
   
3. SQL> startup
   
4. ORACLE instance started.
   
5. 
   
6. Total System Global Area 1252663296 bytes
   
7. Fixed Size 2227944 bytes
   
8. Variable Size 704643352 bytes
   
9. Database Buffers 536870912 bytes
   
10. Redo Buffers 8921088 bytes
    
11. Database mounted.
    
12. ORA-03113: end-of-file on communication channel
    
13. Process ID: 8117
    
14. Session ID: 191 Serial number: 3

网上分析，可能由于昨晚数据库强制关闭，导致文件状态可能不一致，因为正常关闭数据库会同步校验各文件，使得重新启动的时候文件时间点一致。解决方案如下

启动DB

1. SQL> conn / as sysdba
   
2. Connected to an idle instance.
   
3. 
   
4. SQL> startup mount
   
5. ORACLE instance started.

直接reset不成功

1. SQL> select * from v$log;
   
2. 
   
3.     GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
   
4. ---------- ---------- ---------- ---------- ---------- ---------- ---
   
5. STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
   
6. ---------------- ------------- --------- ------------ ---------
   
7.          1 1 112 52428800 512 1 NO
   
8. INACTIVE 3826382 16-JUL-13 3857158 17-JUL-13
   
9. 
   
10.          3 1 114 52428800 512 1 NO
    
11. CURRENT 3886899 17-JUL-13 2.8147E+14
    
12. 
    
13.          2 1 113 52428800 512 1 NO
    
14. INACTIVE 3857158 17-JUL-13 3886899 17-JUL-13
    
15. 
    
16. 
    
17. SQL> alter database open resetlogs 2;
    
18. alter database open resetlogs 2
    
19.                               *
    
20. ERROR at line 1:
    
21. ORA-02288: invalid OPEN mode

恢复数据库

1. SQL> alter database open resetlogs;
   
2. alter database open resetlogs
   
3. *
   
4. ERROR at line 1:
   
5. ORA-01139: RESETLOGS option only valid after an incomplete database recovery
   
6. 
   
7. 
   
8. SQL> recover database until time '2013-07-05'
   
9. Media recovery complete.
   
10. SQL> alter database open resetlogs;
    
11. 
    
12. Database altered.

成功。

转载，原文出自：http://dbanotes.net/Oracle/ORA-03113.htm