在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进程
阅读(2772) | 评论(0) | 转发(0) |