RE: Too many archive log

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Thu, 26 Oct 2000 13:52:21 -0500
Message-Id: <10661.120321@fatcity.com>

Larry,

Basically, archive logs are created from redo logs. They're being generated so quickly because you have a large amount of data being changed in the database. Could this be a batch transaction? In any case, you need to do at least three things here:

Increase the size of your redo logs. I've got a pretty busy OLTP connected to a call center app and I'm running 100M logfiles. How big you make them depends on a variety of factors, including downtime during recovery.
Increase the number of redo logs. I've got six members per group. Even at 100M apiece, I can generate one every couple of minutes during a large upload or purge. One of the considerations here is your disk write speed. If the DB comes back around to an archiving redo log, you wait.....and wait.....and wait.....and wait.....
Sign up for OTN if you haven't already and check out the document called "Managing the Online Redo Log." It's a real good basic primer.

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----

From: Larry Taylor [mailto:ltaylor_at_iq.com] Sent: Thursday, October 26, 2000 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Too many archive log

Hi all,

My database has 2 redo log groups and each group has 3 members. Each members size is 1 meg each.

The problem is that archive logs are generated at a fast rate:

-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091001.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091002.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:21 0000091003.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091004.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091005.arc
-rw-r----- 1 oracle dba 1050112 Oct 23 19:22 0000091006.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:22 0000091007.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091008.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091009.arc
-rw-r----- 1 oracle dba 1052672 Oct 23 19:23 0000091010.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:23 0000091011.arc
-rw-r----- 1 oracle dba 1056256 Oct 23 19:24 0000091012.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091013.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091014.arc
-rw-r----- 1 oracle dba 1056768 Oct 23 19:24 0000091015.arc

Isnt it good practice to keep 3 days worth of archive logs on disk in case needed? If so, what is the best solutions for this high rate logs being generated so often?

Thanks in advance.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Larry Taylor
INET: ltaylor_at_iq.com

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 Received on Thu Oct 26 2000 - 13:52:21 CDT