Alert Log Warnings

From: cmilner <cmilner_at_connect.com.au>
Date: Thu, 13 May 1999 17:45:05 +1000
Message-ID: <373A8300.47399859@connect.com.au>

Hiya,

Getting the follow warnings in Alert log....

Thu May 13 17:39:31 1999
Thread 1 advanced to log sequence 14751

  Current log# 3 seq# 14751 mem# 0: /oradb/07/bta4/log2_3_bta4.dbf
  Current log# 3 seq# 14751 mem# 1: /oradb/08/bta4/log3_3_bta4.dbf
  Current log# 3 seq# 14751 mem# 2: /oradb/06/bta4/log1_3_bta4.dbf

Thu May 13 17:40:11 1999
Thread 1 cannot allocate new log, sequence 14752 Checkpoint not complete

  Current log# 3 seq# 14751 mem# 0: /oradb/07/bta4/log2_3_bta4.dbf
  Current log# 3 seq# 14751 mem# 1: /oradb/08/bta4/log3_3_bta4.dbf
  Current log# 3 seq# 14751 mem# 2: /oradb/06/bta4/log1_3_bta4.dbf

I'm pretty sure this is to do with redo logs not being large enough. I have 2 groups, each 8M, I added a third group 8M, but still get the warnings. Couldn't find any literature in the books either on this.

Database seems be slowing as well!

Any seen this before...

Cheers

Chris Received on Thu May 13 1999 - 02:45:05 CDT