
question about redo log swich and checkpoints
When I look in the alert log I see this:
Current log# 1 seq# 7802300 mem# 0: /u02/oradata/O8I5A/redo01.log
Current log# 1 seq# 7802300 mem# 1: /usr/oracle/redo01.log
Thread 1 advanced to log sequence 7802301
Current log# 4 seq# 7802301 mem# 0: /u02/oradata/O8I5A/redo04.ora
Current log# 4 seq# 7802301 mem# 1: /usr/oracle/redo04.ora
Thread 1 cannot allocate new log, sequence 7802302
Checkpoint not complete
Current log# 4 seq# 7802301 mem# 0: /u02/oradata/O8I5A/redo04.ora
Current log# 4 seq# 7802301 mem# 1: /usr/oracle/redo04.ora
Thread 1 advanced to log sequence 7802302
Current log# 3 seq# 7802302 mem# 0: /u02/oradata/O8I5A/redo03.ora
Current log# 3 seq# 7802302 mem# 1: /usr/oracle/redo03.ora
Thread 1 advanced to log sequence 7802303
Current log# 2 seq# 7802303 mem# 0: /u02/oradata/O8I5A/redo02.log
Current log# 2 seq# 7802303 mem# 1: /usr/oracle/redo02.log
Thread 1 advanced to log sequence 7802304
Current log# 1 seq# 7802304 mem# 0: /u02/oradata/O8I5A/redo01.log
Current log# 1 seq# 7802304 mem# 1: /usr/oracle/redo01.log
Thread 1 advanced to log sequence 7802305
Current log# 4 seq# 7802305 mem# 0: /u02/oradata/O8I5A/redo04.ora
Current log# 4 seq# 7802305 mem# 1: /usr/oracle/redo04.ora
Thread 1 cannot allocate new log, sequence 7802306
Checkpoint not complete
Current log# 4 seq# 7802305 mem# 0: /u02/oradata/O8I5A/redo04.ora
Current log# 4 seq# 7802305 mem# 1: /usr/oracle/redo04.ora
Thread 1 advanced to log sequence 7802306
Current log# 3 seq# 7802306 mem# 0: /u02/oradata/O8I5A/redo03.ora
Current log# 3 seq# 7802306 mem# 1: /usr/oracle/redo03.ora
Thread 1 advanced to log sequence 7802307
Current log# 2 seq# 7802307 mem# 0: /u02/oradata/O8I5A/redo02.log
Current log# 2 seq# 7802307 mem# 1: /usr/oracle/redo02.log
Thread 1 advanced to log sequence 7802308
Current log# 1 seq# 7802308 mem# 0: /u02/oradata/O8I5A/redo01.log
Current log# 1 seq# 7802308 mem# 1: /usr/oracle/redo01.log
Thread 1 advanced to log sequence 7802309
What can be causing this, and how I can solve it?
I have 4 groups with 2 members each on separate drives. Size of the members is 500K. Oracle 8.1.5 on AIX.
No Mutants Allowed

I'd increase the number of groups.

....or get faster disks
but DaPi's advice is usually more reasonable

The log switches are taking place too fast, either because of the small size of the redo log files and/or due a high # of transactions/redo. This is the reason for the error:
Thread 1 cannot allocate new log, sequence 7802302
Checkpoint not complete
Increase the size of the redo log files. Start with file size of say, 5M and tune accordingly.

If you have not Stanby it's better start from 100200Mb

Re: question about redo log swich and checkpoints
Originally posted by arokh
Size of the members is 500K
It's way too small.

Re: Re: question about redo log swich and checkpoints
Originally posted by reydp
It's way too small.
Yes, you should increase them accordingly the load you database have. I'd get the timing of the redo switching and increase the size of the log members so the switching time is no less than 30 minutes.
Also, if the problem arises intermittently you should audit the applications or batch processes that might be generating a large amount of redo information. You can use log miner to see a clearer picture (stats) of what's filling your redo logs.

Thank You for the advices. I increased the size of the redo logs and added two more groups.
No Mutants Allowed
Posting Permissions
 You may not post new threads
 You may not post replies
 You may not post attachments
 You may not edit your posts

Forum Rules

Click Here to Expand Forum to Full Width
