分享程序员开发的那些事...
更新时间：2022-01-10 17:06:53
一： 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>
startupORACLE
instance started.Total
System Global
Area 1252663296 bytes
Fixed
Size
2227944 bytes
Variable
Size
704643352 bytes
Database
Buffers 536870912 bytes
Redo
Buffers 8921088 bytesDatabase
mounted.
ORA-03113:
end-of-file
on
communication channel
Process
ID: 8117Session
ID: 191 Serial number: 3SQL>
conn / as
sysdba
Connected
to
an idle instance.
SQL>
startup mountORACLE
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-13SQL>
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.
成功。