告警日志处理问题1
在alertSID.log日志中出现很多以下信息：<br>Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:<br>Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:<br>Errors in file /u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc:<br>Wed Jul 06 15:45:24 2011<br>Thread 1 cannot allocate new log, sequence 127<br>Private strand flush not complete<br> Current log# 1 seq# 126 mem# 0: /u01/app/oracle/oradata/lsteel/redo01a.log<br> Current log# 1 seq# 126 mem# 1: /u01/app/oracle/oradata/lsteel/redo01b.log<br>Thread 1 advanced to log sequence 127 (LGWR switch)<br> Current log# 3 seq# 127 mem# 0: /u01/app/oracle/oradata/lsteel/redo03a.log<br> Current log# 3 seq# 127 mem# 1: /u01/app/oracle/oradata/lsteel/redo03b.log<br>Wed Jul 06 15:45:27 2011<br>Archived Log entry 138 added for thread 1 sequence 126 ID 0xe7af0c13 dest 1:<br>Archived Log entry 139 added for thread 1 sequence 126 ID 0xe7af0c13 dest 2:<br>Wed Jul 06 18:44:10 2011<br>Thread 1 cannot allocate new log, sequence 128<br><br><br>打开/u01/app/oracle/diag/rdbms/lsteel/lsteel/trace/lsteel_dw00_25295.trc<br>里面有如下信息:<br><br>*** 2011-07-06 12:31:12.844<br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br>kwqberlst rqan->lascn_kwqiia > 0 block <br>kwqberlst rqan->lascn_kwqiia 5 <br>kwqberlst ascn 2373423 lascn 22 <br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br>kwqberlst rqan->lascn_kwqiia > 0 block <br>kwqberlst rqan->lascn_kwqiia 5 <br>kwqberlst ascn 2373423 lascn 22 <br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br>kwqberlst rqan->lascn_kwqiia > 0 block <br>kwqberlst rqan->lascn_kwqiia 5 <br>kwqberlst ascn 2373423 lascn 22 <br>kwqberlst !retval block <br>kwqberlst rqan->lagno_kwqiia 5 <br><br><br><br>解决：增加日志组、增加dbwn进程<br>
页:
[1]