Not necessarily depending on how you've set
log_checkpoint_... or the new parameters related to
bounded recovery time.
hth
connor
- JayMiller_at_TDWaterhouse.com wrote: > Correct.
>
> The only potential disadvantage is that recovery
> will take longer when
> bringing up the database after a crash.
>
>
> Jay Miller
>
> -----Original Message-----
> Sent: Thursday, April 03, 2003 9:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I dissagree, they will be bigger but there will be
> less of them. If
> the amount of processed data does not change, I do
> not think changing the
> size of the redolog files should affect the total
> amount fo bytes to be
> backeup up
>
> Thanks for the recommendation anyway ;)
>
> Cheers,
>
> Fermin.
>
> -----Mensaje original-----
> De: root_at_fatcity.com [mailto:root_at_fatcity.com]En
> 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 operation, but prevents the database from
> hanging during nightly
> batches. No side effects I can think of (except for
> the fact that, of
> course, it will take you longer to backup the
> archived logs since the files
> are bigger, duh ;).
>
> Good luck
> Stefan
>
> Stefan Jahnke
> Consultant
> BOV Aktiengesellschaft
> Voice: +49 201 - 4513-298
> Fax: +49 201 - 4513-149
> mailto: stefan.jahnke_at_nospam.bov.de
> Please remove nospam to contact me via email.
>
> visit our website: http://www.bov.de
> subscribe to our newsletter:
> http://www.bov.de/presse/newsletter.asp
>
> Sicherheitsluecken mit IT-Security-Konzepten von BOV
> effizient schliessen!
> Weitere Informationen unter +49 201/45 13-240 oder
> E-Mail an
> mailto:andrea.palluck_at_bov.de.
>
> Wie Sie wissen, koennen ueber das Internet versandte
> E-Mails leicht unter
> fremden Namen erstellt oder manipuliert werden. Aus
> diesem Grunde bitten
> wir um Verstaendnis dafuer, dass wir zu Ihrem und
> unserem Schutz die
> rechtliche Verbindlichkeit der vorstehenden
> Erklaerungen und Aeusserungen
> ausschliessen.
>
> As you are probably aware, e-mails sent via the
> Internet can easily be
> copied or manipulated by third parties. For this
> reason we would ask for
> your understanding that, for your own protection and
> ours, we must decline
> all legal responsibility for the validity of the
> statements and comments
> given above.
>
>
> -----Ursprüngliche Nachricht-----
> Von: Fermin Bernaus Berraondo
> [mailto:fbernaus_at_sammic.com]
> 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
> 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# 3 seq# 557295 mem# 0:
> /baandata/oradata/baan/redobaan03.log
> Wed Apr 2 23:31:11 2003
> Thread 1 cannot allocate new log, sequence 557296
> Checkpoint not complete
> Current log# 3 seq# 557295 mem# 0:
> /baandata/oradata/baan/redobaan03.log
> Wed Apr 2 23:31:50 2003
>
> In that exact time, everything freezes and the
> database is dead
> until a new redolog can be used.
>
> I have 3 redologs 50 Mb each. I've read that the
> error is because
> too much data is trying to get into the redologs and
> all of them are full,
> Oracle does not have the time to reuse a redolog and
> has to wait until the
> redolog is ready to be reused.
>
> So the solution seems to make these redolog files
> bigger or to
> create new ones. What are the side effects of one or
> the other? will
> performance under normal work be penalised?
>
> ..............................................
> Fermín Bernaus Berraondo
> Dpto. de Informática
> SAMMIC, S.A.
> fbernaus_at_sammic.com
> http://www.sammic.com
> Telf. +34 - 943 157 331
> Fax +34 - 943 151 276
> ..............................................
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Fermin Bernaus Berraondo
> INET: fbernaus_at_sammic.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Stefan Jahnke
> INET: Stefan.Jahnke_at_bov.de
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Fermin Bernaus Berraondo
> INET: fbernaus_at_sammic.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author:
> INET: JayMiller_at_TDWaterhouse.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Connor McDonald
web:
http://www.oracledba.co.uk
web:
http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Yahoo! Plus
For a better Internet experience
http://www.yahoo.co.uk/btoffer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 03 2003 - 20:23:45 CST
