RE: Too many archive log

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 26 Oct 2000 12:40:43 -0400
Message-Id: <10661.120301@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C03F6B.7BBB4076

Content-Type: text/plain;

charset="iso-8859-1"

Three days of arclogs? That would be a dream come true if you have the disk on your arclog destination.

You need to increase the size of your redologs significantly, to a size you are comfortable with. When I started here, our arclogs were 5MB. THey were switching as fast as shown below during loads. I since changed the size to 250MB and everything is peachy.

HTH Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

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

From: Larry Taylor [mailto:ltaylor_at_iq.com] Sent: Thursday, October 26, 2000 1: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 also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C03F6B.7BBB4076

Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Too many archive log</TITLE>
</HEAD>
<BODY>

Three days of arclogs?  That would be a dream = come true if you have the disk on your arclog destination.  =

You need to increase the size of your redologs = significantly, to a size you are comfortable with.  When I started = here, our arclogs were 5MB.  THey were switching as fast as shown = below during loads.  I since changed the size to 250MB and = everything is peachy.

HTH

<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."

-----Original Message----- From: Larry Taylor [<A = HREF=3D"mailto:ltaylor_at_iq.com">mailto:ltaylor_at_iq.com</A>]

<BR><FONT SIZE=3D2>Sent: Thursday, October 26, 2000 1:25 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Too many archive log</FONT>
</P>
<BR>

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?

<P><FONT SIZE=3D2>Thanks in advance.</FONT>
</P>
<BR>

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Larry Taylor</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: ltaylor_at_iq.com</FONT>
</P>

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051 San Diego, =
California        -- Public Internet = access / Mailing Lists
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

-----

 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 = Received on Thu Oct 26 2000 - 11:40:43 CDT