ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Thread 1 cannot allocate new log, sequence 101系统宕机

Thread 1 cannot allocate new log, sequence 101系统宕机

原创 Linux操作系统 作者:jinyuhuahan 时间:2009-04-03 16:29:18 0 删除 编辑

今天数据库突然宕机,查看alert.log看最后出现Thread 1 cannot allocate new log, sequence 101.

分析觉得应该是dbwr写的太慢,但是redo切换的太频繁,日志量比较大造成的.

查看redo

select *  from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARCHIVED STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
         1          1        103  100288000          1 NO       INACTIVE              12308155 2009-4-3 16
         2          1        104  100288000          1 NO       INACTIVE              12308158 2009-4-3 16
         3          1        105  100288000          1 NO       CURRENT               12308162 2009-4-3 16

准备把redo增加到500m

1.增加两个重做日志组

alter database add logfile group 4 '/opt/oracle/oradata/orcl/redo04.log' size 500m;

alter database add logfile group 5 ' /opt/oracle/oradata/orcl/redo05.log' size 500m;

2.切换日志组

alter system switch logfile;

alter system switch logfile;

3.删除3个日志组

alter database drop logfile group1;

alter database drop logfile group2;

alter database drop logfile group3;

4.重新建日志组

alter database add logfile group 1 ' /opt/oracle/oradata/orcl/redo01.log' size 500m;

alter database add logfile group 2 ' /opt/oracle/oradata/orcl/redo02.log' size 500m;

alter database add logfile group 3 ' /opt/oracle/oradata/orcl/redo03.log' size 500m;

5.切换日志组

alter system switch logfile;

alter system switch logfile;

alter system switch logfile;

6删除日志组

alter database logfile group 4

alter database logfile group 5

性能还得在继续观察一段时间.关注

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14870673/viewspace-584584/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-17

  • 博文量
    19
  • 访问量
    24909