+ -
当前位置:首页 → 问答吧 → 急啊!oracle联机日志异常

急啊!oracle联机日志异常

时间:2010-08-09

来源:互联网

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
         3          1     329470  104857600          2 NO  INACTIVE
   5612819040 09-AUG-10

         4          1     329471  104857600          2 NO  CURRENT
   5612820191 09-AUG-10

         5          1     329469  104857600          2 NO  INACTIVE
   5612814825 09-AUG-10

SQL> alter system archive log current;
alter system archive log current
*
ERROR at line 1:
ORA-16038: log 5 sequence# 329469 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 5 thread 1: '/mofprod/oracle/proddata/log05a.dbf'
ORA-00312: online log 5 thread 1: '/mofprod/oracle/proddata/log05b.dbf'

SQL> alter database clear logfile group 5;
alter database clear logfile group 5
*
ERROR at line 1:
ORA-00350: log 5 of thread 1 needs to be archived
ORA-00312: online log 5 thread 1: '/mofprod/oracle/proddata/log05a.dbf'
ORA-00312: online log 5 thread 1: '/mofprod/oracle/proddata/log05b.dbf'


SQL> alter database clear unarchived logfile group 5;

Database altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
         3          1     329470  104857600          2 NO  INACTIVE
   5612819040 09-AUG-10

         4          1     329471  104857600          2 NO  ACTIVE
   5612820191 09-AUG-10

         5          1     329472  104857600          2 NO  CURRENT
   5612873083 09-AUG-10

SQL> alter system switch logfile;
无反应。。。

现在联机日志无法归档。。。

在网上找了半天也没能解决,请问各位有没有解决方法,先谢了!

作者: jcbut2008   发布时间: 2010-08-09

http://www.cnblogs.com/kevinsun/archive/2006/03/02/341046.html

在GOOGLE里输入上面的错误号。这样来找你适合的解决办法。

作者: renxiao2003   发布时间: 2010-08-09