Chinaunix

标题: 告警日志处理问题1 [打印本页]

作者: bealla 时间: 2011-12-22 08:54
标题: 告警日志处理问题1
在alertSID.log日志中出现很多以下信息：
Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:
Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:
Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:
Wed Jul 06 15:45:24 2011
Thread 1 cannot allocate new log, sequence 127
Private strand flush not complete
Current log# 1 seq# 126 mem# 0: /u01/app/oracle/oradata/lsteel/redo01a.log
Current log# 1 seq# 126 mem# 1: /u01/app/oracle/oradata/lsteel/redo01b.log
Thread 1 advanced to log sequence 127 (LGWR switch)
Current log# 3 seq# 127 mem# 0: /u01/app/oracle/oradata/lsteel/redo03a.log
Current log# 3 seq# 127 mem# 1: /u01/app/oracle/oradata/lsteel/redo03b.log
Wed Jul 06 15:45:27 2011
Archived Log entry 138 added for thread 1 sequence 126 ID 0xe7af0c13 dest 1:
Archived Log entry 139 added for thread 1 sequence 126 ID 0xe7af0c13 dest 2:
Wed Jul 06 18:44:10 2011
Thread 1 cannot allocate new log, sequence 128

打开/u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc
里面有如下信息:

*** 2011-07-06 12:31:12.844
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 5
kwqberlst ascn 2373423 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 5
kwqberlst ascn 2373423 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 5
kwqberlst ascn 2373423 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 5

解决：增加日志组、增加dbwn进程

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