Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2015-02-06
1
Medium Priority
?
650 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 23

Accepted Solution

by:
Steve Wales earned 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

971 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