Oracle Database Discussions

Hi,

I've the environment of Oracle 10g (10.2.0.4) on Windows Server 2003 (64-bit) – ARCHIVELOG mode.
I am receiving the following message in my alert log:

Thread 1 advanced to log sequence 59475 (LGWR switch)
Current log# 2 seq# 59475 mem# 0: D:\MYSID\REDOLOG\REDO02.LOG
Wed Jul 05 16:14:07 2010
Thread 1 advanced to log sequence 59476 (LGWR switch)
Current log# 3 seq# 59476 mem# 0: G:\ORADATA\REDOLOGS\REDO03.LOG
Wed Jul 05 16:15:51 2010
Thread 1 cannot allocate new log, sequence 59477
Checkpoint not complete
Current log# 3 seq# 59476 mem# 0: G:\ORADATA\REDOLOGS\REDO03.LOG
Wed Jul 05 16:15:52 2010
Thread 1 advanced to log sequence 59477 (LGWR switch)
Current log# 1 seq# 59477 mem# 0: G:\ORADATA\REDOLOGS\REDO01.LOG
Wed Jul 05 16:16:37 2010
Thread 1 cannot allocate new log, sequence 59478
Checkpoint not complete
Current log# 1 seq# 59477 mem# 0: G:\ORADATA\REDOLOGS\REDO01.LOG
Wed Jul 05 16:16:38 2010
Thread 1 advanced to log sequence 59478 (LGWR switch)
Current log# 2 seq# 59478 mem# 0: D:\MYSID\REDOLOG\REDO02.LOG
Thread 1 cannot allocate new log, sequence 59479
Checkpoint not complete
Current log# 2 seq# 59478 mem# 0: D:\MYSID\REDOLOG\REDO02.LOG
Wed Jul 05 16:16:46 2010
Thread 1 advanced to log sequence 59479 (LGWR switch)
Current log# 3 seq# 59479 mem# 0: G:\ORADATA\REDOLOGS\REDO03.LOG
Wed Jul 05 16:18:28 2010
Thread 1 cannot allocate new log, sequence 59480
Checkpoint not complete
Current log# 3 seq# 59479 mem# 0: G:\ORADATA\REDOLOGS\REDO03.LOG

This happens when the two other group are ACTIVE

SELECT group# "GROUP",
bytes "SIZE",
status "STATUS"
FROM v$log;

GROUP SIZE STATUS
*1 52428800 CURRENT*
*2 52428800 ACTIVE*
*3 52428800 ACTIVE*


Log switch
time - minutes
*2*


My parameters:
log_checkpoint_timeout 1800
log_checkpoint_interval 0
fast_start_mttr_target 0

In AWR report number 5 of Top 5 Timed Events for 6 hours is:
log file switch (checkpoint incomplete)
Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
1,326 403 304 1.4 Configuration

When there is greatest activity Oracle generates one archive log on one minute.

When there are less activities everything is OK.

Should I add one more redo group or increase the size of existing redo files???

Thanks in advance!