Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Checkpoint Not Complete message in Alert Log
Dick B
post May 3 2017, 08:21 AM
Post #1


Advanced Member
***

Group: Members
Posts: 80
Joined: 15-March 12
From: New England
Member No.: 46,936



I have been trying to eliminate issues with the following message sequence in my alert log:

Archived Log entry 1155329 added for thread 1 sequence 560901 ID 0xd8f6e3b dest 1:
Thread 1 cannot allocate new log, sequence 560903
Checkpoint not complete
Current log# 6 seq# 560902 mem# 0: /redo6/prod/redo06.log
Current log# 6 seq# 560902 mem# 1: /redo6/prod/redo06a.log
Thread 1 advanced to log sequence 560903 (LGWR switch)
Current log# 7 seq# 560903 mem# 0: /redo4/prod/redo07.log
Current log# 7 seq# 560903 mem# 1: /redo4/prod/redo07a.log

I originally had set up 3 redo log groups, but I've expanded that to 6 - each of 100Mb per file, with 2 files per group. The number of messages has been reduced since I've
done that, but the messages still seem to pop up with enough regularity that I want to eliminate them completely. In reading about this situation, it appears that the
FAST_START_MTTR_TARGET (set to 0) and the LOG_CHECKPOINT_INTERVAL (set to 0) and LOG_CHECKPOINT_TIMEOUT (set to 0) are all involved in eliminating the
issue, but I am not sure if there is anything else I should tweak - my LOG_BUFFER value is 8486912.

It would seem that adding additional redo log groups might be enough to eliminate the problem, but I don't want to do that if that's not the best way to address the issue.

Thanks for any insight anyone might be able to provide.
Go to the top of the page
 
+Quote Post
Dick B
post May 3 2017, 08:23 AM
Post #2


Advanced Member
***

Group: Members
Posts: 80
Joined: 15-March 12
From: New England
Member No.: 46,936



QUOTE (d*** B @ May 3 2017, 09:21 AM) *
I have been trying to eliminate issues with the following message sequence in my alert log:

Archived Log entry 1155329 added for thread 1 sequence 560901 ID 0xd8f6e3b dest 1:
Thread 1 cannot allocate new log, sequence 560903
Checkpoint not complete
Current log# 6 seq# 560902 mem# 0: /redo6/prod/redo06.log
Current log# 6 seq# 560902 mem# 1: /redo6/prod/redo06a.log
Thread 1 advanced to log sequence 560903 (LGWR switch)
Current log# 7 seq# 560903 mem# 0: /redo4/prod/redo07.log
Current log# 7 seq# 560903 mem# 1: /redo4/prod/redo07a.log

I originally had set up 3 redo log groups, but I've expanded that to 6 - each of 100Mb per file, with 2 files per group. The number of messages has been reduced since I've
done that, but the messages still seem to pop up with enough regularity that I want to eliminate them completely. In reading about this situation, it appears that the
FAST_START_MTTR_TARGET (set to 0) and the LOG_CHECKPOINT_INTERVAL (set to 0) and LOG_CHECKPOINT_TIMEOUT (set to 0) are all involved in eliminating the
issue, but I am not sure if there is anything else I should tweak - my LOG_BUFFER value is 8486912.

It would seem that adding additional redo log groups might be enough to eliminate the problem, but I don't want to do that if that's not the best way to address the issue.

Thanks for any insight anyone might be able to provide.


I forgot to mention that I am running 11.2.0.3, on HP-UX 11.31.
Go to the top of the page
 
+Quote Post
burleson
post May 3 2017, 01:55 PM
Post #3


Advanced Member
***

Group: Members
Posts: 13,531
Joined: 26-January 04
Member No.: 13



Hi D I c k,

>> Thread 1 cannot allocate new log, sequence

Please see my notes on this error here:

http://www.dba-oracle.com/t_thread_cannot_...og_sequence.htm




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 09:34 AM