Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 713
  • Last Modified:

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

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
joe_echavarria
Asked:
joe_echavarria
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now