Sample Header Ad - 728x90

Oracle alert.log "Thread 1 cannot allocate new log" on AWS RDS

0 votes
1 answer
258 views
I migrated from an on-premise Oracle XE to Amazon RDS. It's running on a T3.medium server with gp3 storage (200 GB/12000 IOPS). Almost every fifth minute the alert.log says like this: "Thread 1 cannot allocate new log, sequence 10209 Checkpoint not complete" 3-4 seconds after that it logs another message: "Thread 1 advanced to log sequence 10209 (LGWR switch), current SCN: 472780758" And immediately after that: "ARC1 (PID:6427): Archived Log entry 10205 added for B-1189761742.T-1.S-10208 ID 0x7efecf3c1c4d LAD:1 [krse.c:4934]" Like this: Log excerpt Reading about the first message ("cannot allocate new log") it seems as a "bad" message. The typical advice is to increase the redo log file size. So I added 4 log files, each 512 Mb. The advice was to remove the old log (128 Mb each) files but they are almost always "ACTIVE" so I have just managed to remove 1. This is the current status: Log files ... and I still get the error message in alert.log. The parameter archive_lag_target is set to 300 (5 minutes), so I guess that's why it switches log file every five minutes. (I don't think I can change that setting in RDS.) Looking at the disk operations in AWS doesn't imply that the disk is under too heavy load: Disk queue depth EBS IO operations Redo size Should i be worried about the message "Thread 1 cannot allocate new log..."? If yes: what can be the reason for it and what can I do about it? **Update:** When I issued a manual checkpoint using: EXEC rdsadmin.rdsadmin_util.checkpoint; ... it did a checkpoint in less than a second and all but one log file became INACTIVE. It seems as if it doesn't do automatic checkpoints.
Asked by Björn (133 rep)
Feb 11, 2025, 11:35 AM
Last activity: Mar 5, 2025, 09:21 PM