Database Administration (MOSC)

MOSC Banner

LGWR switch happening frequently

edited Oct 25, 2021 7:03PM in Database Administration (MOSC) 13 commentsAnswered ✓

Hi, in my alert_orcl.log file I'm seeing a lot of LGWR switch messages. I've Googled and searched this forum and the result is primarily just "find the program causing it" but I'm not sure what would result in the log switching to happen.

alert_orcl.log

2021-10-25T11:35:10.335838-04:00
Thread 1 cannot allocate new log, sequence 15292
Private strand flush not complete
  Current log# 3 seq# 15291 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_3_j4dx3spf_.log
  Current log# 3 seq# 15291 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_3_j4dx3sy6_.log
2021-10-25T11:35:13.348819-04:00
Thread 1 advanced to log sequence 15292 (LGWR switch)
  Current log# 1 seq# 15292 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_1_j4dx3so6_.log
  Current log# 1 seq# 15292 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_1_j4dx3ssw_.log
2021-10-25T12:47:09.418954-04:00
Thread 1 advanced to log sequence 15293 (LGWR switch)
  Current log# 4 seq# 15293 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_4_jovynwbz_.log
  Current log# 4 seq# 15293 mem# 1: /u01/app/oracle/fast_recovery_area/orcl/ORCL/onlinelog/o1_mf_4_jovynwdz_.log
2021-10-25T13:00:12.190819-04:00
Thread 1 cannot allocate new log, sequence 15294
Private strand flush not complete
  Current log# 4 seq# 15293 mem# 0: /u02/oradata/orcl/ORCL/onlinelog/o1_mf_4_jovynwbz_.log
  Current log# 4 seq# 15293

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center