作者：J_ai糖 | 来源：互联网 | 2014-07-08 01:11
ORA-03113:end-of-fileoncommunicationchannel解决www.2cto.com今天模拟INACTIVE的日志组丢失情况，遭遇ORA-03113SQL>selectgroup#,archived,statusfromv$log;GROUP#ARCSTATUS-----...
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
处于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
数据库成功打开。
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 