DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: checkpoint

  1. #1
    Join Date
    Feb 2001
    Posts
    107
    I am getting the message checkpoint not complete in the alert_log my production database. Can anyone point me in the right direction

    Thanks


    Few lines from the alert_log


    Checkpoint not complete
    Current log# 3 seq# 5670 mem# 0: /oradata/ORD/redo03.log
    Current log# 3 seq# 5670 mem# 1: /oradata/ORD/redo03m.log
    Thread 1 advanced to log sequence 5671
    Current log# 1 seq# 5671 mem# 0: /oradata/ORD/redo01.log
    Current log# 1 seq# 5671 mem# 1: /oradata/ORD/redo01m.log
    Thread 1 advanced to log sequence 5672
    Current log# 2 seq# 5672 mem# 0: /oradata/ORD/redo02.log
    Current log# 2 seq# 5672 mem# 1: /oradata/ORD/redo02m.log
    Thread 1 advanced to log sequence 5673
    Current log# 3 seq# 5673 mem# 0: /oradata/ORD/redo03.log
    Current log# 3 seq# 5673 mem# 1: /oradata/ORD/redo03m.log
    Thread 1 cannot allocate new log, sequence 5674
    Checkpoint not complete
    Current log# 3 seq# 5673 mem# 0: /oradata/ORD/redo03.log
    Current log# 3 seq# 5673 mem# 1: /oradata/ORD/redo03m.log
    Thread 1 advanced to log sequence 5674
    Current log# 1 seq# 5674 mem# 0: /oradata/ORD/redo01.log
    Current log# 1 seq# 5674 mem# 1: /oradata/ORD/redo01m.log
    Thread 1 advanced to log sequence 5675
    Current log# 2 seq# 5675 mem# 0: /oradata/ORD/redo02.log
    Current log# 2 seq# 5675 mem# 1: /oradata/ORD/redo02m.log

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do a search about checkpoint not complete in forum you will find many threads related to this

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width