ORA-03113: end-of-file on communication channel 报错的问题

   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.
故障问题：
ORA-03113: end-of-file on communication channel 
Process ID: 32688 
Session ID: 202 Serial number: 3




startup mount;


select * from v$log;


recover database until time '2015-03-16'


alter system set db_recovery_file_dest_size=20480M; 






更改归档路径：


D:\oracle\archlog


alter system set log_archive_dest_1='location=D:\oracle\archlog';


alter system set log_archive_dest_1='location=D:\oracle\archlog' scope=spfile;




 alter system set log_archive_start=false scope=spfile;


shutdown immediate