一： 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
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
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.
成功。
