Thread 1 cannot allocate new log, sequence XXXX
Hello I noticed in my alert log file flood of messages like:
Thread 1 cannot allocate new log, sequence 42396
Checkpoint not complete
Number of checkpoints in last week:
DAY 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00
----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- ----- -----
01/04 11 10 10 88 48 37 48 55 60 64 57 56 49 54 47 48 43 36 27 28 29 32 29 21
31/03 6 8 0 23 8 9 8 69 9 19 9 8 18 7 19 9 8 18 9 13 11 8 9 8
30/03 14 11 29 10 23 12 83 14 14 16 14 13 13 79 11 10 9 9 9 8 8 7 7 6
29/03 40 13 35 48 60 40 36 46 48 54 49 54 47 50 58 41 39 108 21 16 12 11 11 11
28/03 33 28 83 154 34 36 39 44 47 48 57 92 46 44 46 43 43 32 21 17 14 12 13 12
27/03 35 24 70 23 28 36 42 44 41 40 44 43 41 43 45 48 41 34 26 19 15 14 12 11
26/03 18 15 75 16 28 34 45 48 50 46 43 45 47 51 45 44 44 168 97 18 15 13 14 11
Log sizes:
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- ---------- --- ----------------
1 1 47425 104857600 512 2 YES ACTIVE
2 1 47426 104857600 512 2 YES ACTIVE
3 1 47427 104857600 512 2 NO CURRENT
4 1 47424 104857600 512 2 YES ACTIVE
I saw recommendation to set:
alter system set archive_lag_target=0 scope=both;
According to number of switches close to one per minute, to reduce to 6 recommended by Oracle I need to increase size ten times so each redo log will have 1 GB. Is this value correct or maybe will be better to add more log groups ?