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.
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.