| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert.log - check point not complete???
Are you still having this problem? Do you have async_io=true in your init.ora? We were experiencing this same sort of problem, no matter how many log groups we had, log sizes of approx. 60M per member, and 5 groups. We found that we were performing quite a few checkpoints other than the log switches. i.e. We'd have approx. 60 log switches during nightly processing and thousands of checkpoints. We finally figured out that our DBWR was lazy or unable to keep up. We turned off async_io and set db_writers=4 and our problem mostly disappeared. We then increased db_writers=6 and then increased the log_buffer size and have not been experiencing this problem.
HTH
Eric Peterson, DBA
Maurices Inc.
eric_NOpeterson_at_mauricesSPAMMERS.inrg.comALLOWED
Note that the views I have expressed are solely my own and not that of my employer. To email me directly, remove the NO SPAMMERS ALLOWED from the email address.
In article <38D8B59E.1782_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> loi_huynh_at_my-deja.com wrote:
> >
> > I checked the disk is only 78% fill.
> > Closer look at the log, it failed to allocate but then succeed e.g.
> > sequence number 24029. There are at lease a dozen entries like
this in
> > the log.
> >
> > Pls advise,
> >
> > Many thanks,
> >
> > LHUYNH.
> >
> > /########################################################/
> > Checkpoint not complete
> > Current log# 1 seq# 24025 mem# 0: /mnt/oracle/log1.dbf
> > Thread 1 advanced to log sequence 24026
> > Current log# 2 seq# 24026 mem# 0: /mnt/oracle/log2.dbf
> > Thread 1 advanced to log sequence 24027
> > Current log# 3 seq# 24027 mem# 0: /mnt/oracle/log3.dbf
> > Thread 1 advanced to log sequence 24028
> > Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> > Thread 1 cannot allocate new log, sequence 24029
> > Checkpoint not complete
> > Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> > Thread 1 advanced to log sequence 24029
> > Current log# 2 seq# 24029 mem# 0: /mnt/oracle/log2.dbf
> > Thread 1 advanced to log sequence 24030
> > Current log# 3 seq# 24030 mem# 0: /mnt/oracle/log3.dbf
> > Thread 1 advanced to log sequence 24031
> > Current log# 1 seq# 24031 mem# 0: /mnt/oracle/log1.dbf
> > Thread 1 advanced to log sequence 24032
> > Current log# 2 seq# 24032 mem# 0: /mnt/oracle/log2.dbf
> > Thread 1 advanced to log sequence 24033
> > Current log# 3 seq# 24033 mem# 0: /mnt/oracle/log3.dbf
> > Thread 1 advanced to log sequence 24034
> > Current log# 1 seq# 24034 mem# 0: /mnt/oracle/log1.dbf
> > /########################################################/
> >
> > In article <8b9s7b$2d0$1_at_nnrp1.deja.com>,
> > www_dba_at_my-deja.com wrote:
> > >
> > >
> > > Hi,
> > >
> > > It seems that you are running archivelog mode.
> > > But you are running out of hard disk space.
> > >
> > > HTH.
> > >
> > > In article <8b9jj6$pav$1_at_nnrp1.deja.com>,
> > > loi_huynh_at_my-deja.com wrote:
> > > > Hi,
> > > > I am getting the following errors in Alert.log but not quite
sure
what
> > > > are their ramifications. It says "check point not complete" and
"Thread
> > > > x cannot allocate new log sequence".
> > > > Pls advise, thanks,
> > > > LHUYNH.
> > > > /#################################/
> > > > Current log# 2 seq# 24026 mem# 0: /mnt/oracle/log2.dbf
> > > > Thread 1 advanced to log sequence 24027
> > > > Current log# 3 seq# 24027 mem# 0: /mnt/oracle/log3.dbf
> > > > Thread 1 advanced to log sequence 24028
> > > > Current log# 1 seq# 24028 mem# 0: /mnt/oracle/log1.dbf
> > > > Thread 1 cannot allocate new log, sequence 24029
> > > > Checkpoint not complete
> > > > /#################################/
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Apr 11 2000 - 00:00:00 CDT
 |
 |