Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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…

707 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

17 Experts available now in Live!

Get 1:1 Help Now