ORA-03113:end-of-file on communication channel解决
www.2cto.com
今天模拟INACTIVE的日志组丢失情况，遭遇 ORA-03113
SQL> select group#,archived,status from v$log;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 YES INACTIVE
3 YES INACTIVE
SQL> select member from v$logfile where group#=3;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/xyhui11g/redo03.log
[oracle@xyhui trace]$ cd /u01/app/oracle/oradata/xyhui11g/
[oracle@xyhui xyhui11g]$ rm redo03.log
然后startup无法打开
数据库。
处于INACTIVE状态，实例恢复已经不需要这个日志组。执行
SQL> startup mount
ORACLE instance started.
Total System Global Area 630501376 bytes
Fixed Size 2215984 bytes
Variable Size 473960400 bytes
Database Buffers 150994944 bytes
Redo Buffers 3330048 bytes
Database mounted.
SQL> alter database clear logfile group 3;
Database altered.
SQL> alter database open;
Database altered.
SQL> select group#,archived,status from v$log;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 YES INACTIVE
3 YES UNUSED
SQL> exit
数据库成功打开。