Solved

---Private strand flush not complete---   and  ---Checkpoint not complete--- messages in the alert log file.

Posted on 2015-02-06
1
527 Views
Last Modified: 2015-02-18
Hi,

  Below is a part of my arlet log file.    I have two strange message   Private strand flush not complete   and Checkpoint not complete.   What does messages means ?   How to solve this ?
  Users are complaning about the sytem being slow

  Thank you.


Thread 1 advanced to log sequence 61321 (LGWR switch)
  Current log# 1 seq# 61321 mem# 0: E:\ORADATA\xxxxxx\REDO01.LOG
Fri Feb 06 07:24:33 2015
Thread 1 advanced to log sequence 61322 (LGWR switch)
  Current log# 2 seq# 61322 mem# 0: E:\ORADATA\xxxxxx\REDO02.LOG
Fri Feb 06 07:32:57 2015
Thread 1 advanced to log sequence 61323 (LGWR switch)
  Current log# 3 seq# 61323 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
Fri Feb 06 07:43:50 2015
Thread 1 advanced to log sequence 61324 (LGWR switch)
  Current log# 1 seq# 61324 mem# 0: E:\ORADATA\xxxxxx\REDO01.LOG
Fri Feb 06 07:51:57 2015
Thread 1 advanced to log sequence 61325 (LGWR switch)
  Current log# 2 seq# 61325 mem# 0: E:\ORADATA\xxxxxx\REDO02.LOG
Fri Feb 06 07:59:39 2015
Thread 1 advanced to log sequence 61326 (LGWR switch)
  Current log# 3 seq# 61326 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
Fri Feb 06 08:01:27 2015
Starting control autobackup
Control autobackup written to DISK device
      handle 'T:\BACKUPS\xxxxxx\RMAN\C-1936131573-20150206-00'
Fri Feb 06 08:01:40 2015
ALTER SYSTEM ARCHIVE LOG
Fri Feb 06 08:01:41 2015
Thread 1 cannot allocate new log, sequence 61327
Checkpoint not complete
  Current log# 3 seq# 61326 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
Thread 1 cannot allocate new log, sequence 61327
Private strand flush not complete
  Current log# 3 seq# 61326 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
Fri Feb 06 08:01:48 2015
Thread 1 advanced to log sequence 61327 (LGWR switch)
  Current log# 1 seq# 61327 mem# 0: E:\ORADATA\xxxxxx\REDO01.LOG
Fri Feb 06 08:06:59 2015
Starting control autobackup
Control autobackup written to DISK device
      handle 'T:\BACKUPS\xxxxxx\RMAN\C-1936131573-20150206-01'
Fri Feb 06 08:09:00 2015
Thread 1 cannot allocate new log, sequence 61328
Checkpoint not complete
  Current log# 1 seq# 61327 mem# 0: E:\ORADATA\xxxxxx\REDO01.LOG
Fri Feb 06 08:09:05 2015
Thread 1 advanced to log sequence 61328 (LGWR switch)
  Current log# 2 seq# 61328 mem# 0: E:\ORADATA\xxxxxx\REDO02.LOG
Fri Feb 06 08:30:46 2015
Thread 1 advanced to log sequence 61329 (LGWR switch)
  Current log# 3 seq# 61329 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
Fri Feb 06 08:49:07 2015
Thread 1 advanced to log sequence 61330 (LGWR switch)
  Current log# 1 seq# 61330 mem# 0: E:\ORADATA\xxxxxx\REDO01.LOG
Fri Feb 06 08:59:41 2015
Thread 1 advanced to log sequence 61331 (LGWR switch)
  Current log# 2 seq# 61331 mem# 0: E:\ORADATA\xxxxxx\REDO02.LOG
Fri Feb 06 09:04:47 2015
Thread 1 advanced to log sequence 61332 (LGWR switch)
  Current log# 3 seq# 61332 mem# 0: E:\ORADATA\xxxxxx\REDO03.LOG
0
Comment
Question by:joe_echavarria
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 40593930
Check out this article at Oracle Support:

Alert Log Messages: Private Strand Flush Not Complete (Doc ID 372557.1)

Also, there was a discussion here not so very long ago about this topic where there was quite a bit of detailed talk about the cannot allocate message.

http://www.experts-exchange.com/Database/Oracle/Q_28353638.html

Bottom line here is that, for the vast majority of cases, these messages can be safely ignored.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question