oracle联机重做日志文件丢失&&&&Oracle错误ORA-03113: end-of-file on communication channel处理办法

一：　1.  在oracle正常运行过程中，强行删除联机重做数据库，而后强制关闭数据库

SQL> host rm -rf '/u01/oradata/orcl/redo01.log'

SQL> shutdown abort;
ORACLE instance shut down

2.而后重启数据库，出现如下错误

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size    2217952 bytes
Variable Size  528484384 bytes
Database Buffers  301989888 bytes
Redo Buffers    2412544 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 12350
Session ID: 1 Serial number: 5

 

此时应以mount方式启动数据库

SQL> startup mount
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size    2217952 bytes
Variable Size  528484384 bytes
Database Buffers  301989888 bytes
Redo Buffers    2412544 bytes
Database mounted.
SQL> alter database clear logfile group 1;

Database altered.

SQL> alter database open;

 

 

二，　以shutdown abort 形式关闭数据库，而后重启数据库，Oracle错误ORA-03113: end-of-file on communication channel处理办法

 

SQL> startup
ORACLE instance started.

Total System GlobalArea 1252663296 bytes
FixedSize2227944 bytes
VariableSize704643352 bytes
DatabaseBuffers 536870912 bytes
Redo Buffers 8921088 bytes
Databasemounted.
ORA-03113:end-of-fileoncommunication channel
Process ID: 8117
Session ID: 191 Serial number: 3
SQL> conn / assysdba
Connectedtoan idle instance.

SQL> startup mount

ORACLE instance started.
直接reset不成功
SQL>select* fromv$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
CURRENT3886899 17-JUL-13 2.8147E+14

         2 1 113 52428800 512 1 NO
INACTIVE 3857158 17-JUL-13 3886899 17-JUL-13


SQL>alterdatabase open resetlogs 2;
alterdatabase open resetlogs 2

                              *
ERRORatline 1:
ORA-02288: invalid OPENmode
恢复数据库
SQL>alterdatabase open resetlogs;
alterdatabase open resetlogs
*
ERRORatline 1:
ORA-01139: RESETLOGS optiononly valid afteran incomplete databaserecovery


SQL> recover databaseuntil time'2013-07-05'
Media recovery complete.
SQL>alterdatabase open resetlogs;

Databasealtered.
成功。