RE: redo logs

From: Galleri, Mariana <MGalleri_at_uniFON.com.ar>
Date: Wed, 12 Jul 2000 13:52:28 -0300
Message-Id: <10556.111827@fatcity.com>

Hi,

that's means that your database is archivelog mode and all redolog = files
need archiving.

Check how many redologs the DB has and what size they are. Maybe, you should increase the number of redolog files, so, the cycle = is
longer.
Check log_checkpoint_timeout and log_checkpoint_interval parameters. = First
should be 0 and the other * OS block size should be bigger than the = redolog
size if you only want that a checkpoint occurs when the redolog file = current
is full.
How much time does the DB spend archiving a redolog file?. Check log_archive_buffers, log_archive_buffer_size. Are the redolog files mirrored? What about asyncio?

Regards.

-----Mensaje original-----
De: achoto_at_american.edu [mailto:achoto_at_american.edu] Enviado el: Mi=E9rcoles 12 de Julio de 2000 12:50 Para: Multiple recipients of list ORACLE-L Asunto: 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

--=20
Author:=20
  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). Received on Wed Jul 12 2000 - 11:52:28 CDT