RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread DENNIS WILLIAMS
ipients of list ORACLE-L Asunto: RE: Cannot allocate new log - checkpoint not complete Its not really a particular redo log that is the issue. You've used up redo's (say) 1, 2, 3 and you want to cycle around to 1 but the checkpoint that would free up redo 1 is not yet finished. Thus its no

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Cary Millsap
t if keeping datafiles and one of the redolog files in the same device should affect performance, then I wonder why the "cannot allocate new log, checkpoint not complete" message is affecting to the 3 redolog files and not only to the one located in that datafile device. I did

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Fermin Bernaus Berraondo
, 04 de abril de 2003 11:49 Para: Multiple recipients of list ORACLE-L Asunto: RE: Cannot allocate new log - checkpoint not complete Its not really a particular redo log that is the issue. You've used up redo's (say) 1, 2, 3 and you want to cycle around to 1 but the checkpoint that wou

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Connor McDonald
data files (/baandata). > > All of them are mirrored disks. > > Your comment makes sense, but if keeping datafiles > and one of the redolog files in the same device > should affect performance, then I wonder why the > "cannot allocate new log, checkpoint

AW: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Stefan Jahnke
ernaus Berraondo [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a

AW: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Stefan Jahnke
alidity of the statements and comments given above. -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 19:44 An: Multiple recipients of list ORACLE-L Betreff: RE: Cannot allocate new log - checkpoint not complete Correct.

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Fermin Bernaus Berraondo
: Multiple recipients of list ORACLE-L Asunto: RE: Cannot allocate new log - checkpoint not complete There are some other effects I can think of. Up to you if these are important / significant to your users. If you make them bigger and you have a standby database then the standby might end up

RE: Cannot allocate new log - checkpoint not complete

2003-04-04 Thread Fermin Bernaus Berraondo
---Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de DENNIS WILLIAMS Enviado el: jueves, 03 de abril de 2003 17:04 Para: Multiple recipients of list ORACLE-L Asunto: RE: Cannot allocate new log - checkpoint not complete Fermin - Connor's reply sparked an idea. B

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Reardon, Bruce (CALBBAY)
EMAIL PROTECTED] Gesendet: Donnerstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Connor McDonald
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > nombre de Stefan Jahnke > Enviado el: jueves, 03 de abril de 2003 15:44 > Para: Multiple recipients of list ORACLE-L > Asunto: AW: Cannot allocate new log - checkpoint not > complete > > > Hi > > I would suggest to in

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread JayMiller
PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke Enviado el: jueves, 03 de abril de 2003 15:44 Para: Multiple recipients of list ORACLE-L Asunto: AW: Cannot allocate new log - checkpoint not complete Hi I would suggest to increase the redo log size. Doesn't effect you during daily oper

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Fermin Bernaus Berraondo
;) Cheers, Fermin. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Stefan Jahnke Enviado el: jueves, 03 de abril de 2003 15:44 Para: Multiple recipients of list ORACLE-L Asunto: AW: Cannot allocate new log - checkpoint not complete Hi I would suggest to increase

RE: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread DENNIS WILLIAMS
Fermin - Connor's reply sparked an idea. By any chance do you have your redo logs on the same device as your data files? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 03, 2003 5:04 AM To: Multiple recipients of list ORA

AW: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Stefan Jahnke
rstag, 3. April 2003 10:04 An: Multiple recipients of list ORACLE-L Betreff: Cannot allocate new log - checkpoint not complete I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is

Re: Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Connor McDonald
Basically as the message suggests the redo cannot be recycled until the checkpoint has completed flushing out the cache. A *workaround* is to add redo log (size or number) but its really a heads-up about your I/O subsystem not being up to keep up under stress. hth connor --- Fermin Bernaus Be

Cannot allocate new log - checkpoint not complete

2003-04-03 Thread Fermin Bernaus Berraondo
I think I am having problems with my redologs. Under normal circumstances no errors arise, but if I do a massive import of data as I was doing last night, this is what alertSID.log shows from time to time: Wed Apr 2 23:29:52 2003 Thread 1 advanced to log sequence 557295 Current log#