适用范围

Oracle 11G及以上版本，Linux X86-64平台

问题概述

数据库LGWR进程的TRACE日志显示一条Warning信息：

*** 2022-05-18 22:45:06.840
Warning: log write broadcast wait time 1170540ms (SCN 0xe.49c4362d)

数据库日志在这个时间段无其他异常告警，同时业务那边未发觉任何异常情况。

查看LMS进程TRACE日志，在故障时间段内未发现DRM：

*** 2022-05-19 11:14:29.237
DRM(2248) win(1) lms 0 finished drm freeze 
DRM(2248) win(1) lms 0 finished replaying gcs resources
DRM(2248) win(1) lms 0 finished fixing gcs write protocol 
* lms 0 finished parallel drm freeze in DRM(2248) window 2, pcount 160 
DRM(2248) win(2) lms 0 finished drm freeze 
DRM(2248) win(2) lms 0 finished replaying gcs resources
DRM(2248) win(2) lms 0 finished fixing gcs write protocol 
* lms 0 finished parallel drm freeze in DRM(2248) window 3, pcount 160 
DRM(2248) win(3) lms 0 finished drm freeze 
DRM(2248) win(3) lms 0 finished replaying gcs resources
DRM(2248) win(3) lms 0 finished fixing gcs write protocol