Solved

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

Posted on 2015-02-06
1
409 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Finace 3 67
Get FileTypes from a list of FileNames  in a Table field 18 43
Oracle and DateTime math 6 26
Oracle 10g standard edition server with 4 processors 3 37
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now