Chinaunix

标题: 急啊！oracle联机日志异常 [打印本页]

作者: jcbut2008 时间: 2010-08-09 14:08
标题: 急啊！oracle联机日志异常
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;
无反应。。。

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

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

作者: renxiao2003 时间: 2010-08-09 15:06
http://www.cnblogs.com/kevinsun/archive/2006/03/02/341046.html

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

作者: duolanshizhe 时间: 2010-08-10 11:54
既然你开启了归档模式，那写满的联机日志当然需要归档了。

为啥无法归档，你要找出原因：

1、是本地归档，还是远程归档？
2、归档目录是否够用，空间是否充足，权限是否正常？
3、一般不建议直接clear联机日志的，很危险的操作！

请贴出alert日志，以便进一步分析，不然也是胡乱猜测而已！

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)