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
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
, 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
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
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
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.
: 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
---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
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
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
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
;)
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
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
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
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
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#
16 matches
Mail list logo