RE: redo logs

Hello,

I had this problem recently, and the archivelog dest was NOT full. Instead, a new process had been scheduled to run twice a day which churned through more redologs in 5 min than the rest of the system required in 24 hours, so we were very rapidly cycling through all groups. There was a slight delay while the archiver caught up, the redo log would successfully switch and all was well again. In my case, I increased the size of the redologs and the number of groups, and the error messages stopped. The process itself is the real culprit, but it's vendor delivered and part of security, so we're stuck. (But of course, they promised it will be improved in the next release <yawn>.)

If this sounds similar to your situation, reevaluate your redolog size, number of groups and checkpoint frequency. If this error appears infrequently and log switches and checkpoints are generally occurring at a reasonable interval, try increasing the number of groups. However, if this is a common problem, or logfiles switches are close together and causing frequent checkpoints, try increasing the size of the redolog files.

Gurus, correct me where necessary please!

Robyn

"Norris, Greg" <Greg_Norris_at_mail.dor.state.mo.us> on 07/12/2000 02:08:19 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Robyn Sands/US1/Lend Lease)

Subject: RE: redo logs

Make sure that your LOG_ARCHIVE_DEST filesystem isn't full...

> -----Original Message-----
> From: achoto_at_american.edu [mailto:achoto_at_american.edu]
> Sent: 12 July, 2000 10:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: redo logs
>
>
> We're getting the following messages in the alert log. Can a
> kind soul in
> the list enlighten me with potential problems and the possible cause?
> Thanks in advance.
>
> Thread 1 advanced to log sequence 7048
> Current log# 2 seq# 7048 mem# 0:
> /oracle03/oradata/ORTE/redoORTE02.log
> Wed Jul 12 06:30:47 2000
> Thread 1 cannot allocate new log, sequence 7049
> Checkpoint not complete
> Current log# 2 seq# 7048 mem# 0:
> /oracle03/oradata/ORTE/redoORTE02.log
> Wed Jul 12 06:31:12 2000
>
> Thanks
>
> Ana E. Choto
> Systems Programmer
> American University
> Office of Information Technology
> Phone (202) 885-2275
> Fax (202) 885-2224
>
> --
> Author:
> INET: achoto_at_american.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
>

--
Author: Norris, Greg
  INET: Greg_Norris_at_mail.dor.state.mo.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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