RE: Too many archive log

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 26 Oct 2000 13:45:44 -0700
Message-Id: <10661.120353@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_01C03F8D.B600EDF0
Content-Type: text/plain;

charset="iso-8859-1"

Two words Roy.. Check Point ;)

Satar

> -----Original Message-----
> From: Roy Ferguson [SMTP:rferguso_at_level1.com]
> Sent: Thursday, October 26, 2000 8:52 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Too many archive log
>
>
> Winnie,
>
> just curious, but what are the recovery issues if you are only switching
> every
> 1/2 hour?...I understand the cost of generating archive logs at 4 a minute
> but
> if it's 1 every 30 minutes don't you run the risk of loosing 30MG of data
> if a
> crash were to happen?
>
> Roy
>
>
> >
> >
> >
> > Gee.. 1MB redolog file is WAY too small!! You should definitely
> increased
> > the size of the redo log.
> >
> > It is very costly for Oracle to do the log switch. You would want to
> have
> > it doing a switch about every 30 minutes only. You will have less
> > archivelog this way, but the size of the logs will be bigger.
> >
> > Winnie
> >
> >
> >
> >
> >
> > Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 10/26/2000 10:25:28 AM
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > Sent by: root_at_fatcity.com
> >
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc:
> >
> >
> >
> > 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).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Winnie_Liu_at_infonet.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).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Roy Ferguson
> INET: rferguso_at_level1.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_01C03F8D.B600EDF0
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=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

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

Two words = Roy..  Check Point   ;)

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satar</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Roy Ferguson [SMTP:rferguso_at_level1.com] Sent:   Thursday, October 26, 2000 8:52 PM To:     Multiple recipients of list ORACLE-L Subject:       =

</B> <FONT SIZE=3D1 FACE=3D"Arial">Re: Too many archive log</FONT>
</P>
<BR>

Winnie,

just curious, but what are the = recovery issues if you are only switching every 1/2 hour?...I understand the cost of = generating archive logs at 4 a minute but if it's 1 every 30 minutes don't you = run the risk of loosing 30MG of data if a crash were to happen?

<P><FONT SIZE=3D2 FACE=3D"Arial">Roy</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

> > Gee.. 1MB redolog file is WAY = too small!! You should definitely increased

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; the size of the redo log.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; It is very costly for Oracle to =

do the log switch. You would want to have > it doing a switch about every 30 = minutes only. You will have less
 > archivelog this way, but the = size of the logs will be bigger.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Winnie</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Larry Taylor =

<ltaylor_at_iq.com>@fatcity.com on 10/26/2000 10:25:28 AM > > Please respond to = ORACLE-L_at_fatcity.com
 > > Sent by:  = root_at_fatcity.com

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; To:&nbsp;&nbsp; Multiple =

recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; cc:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Hi all,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; 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:

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; -rw-r-----&nbsp;&nbsp; 1 =
oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Thanks in advance.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; 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 FACE=3D"Arial">&gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: Larry Taylor</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

ltaylor_at_iq.com
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

NT>
 > 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).

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; 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 FACE=3D"Arial">&gt; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

Winnie_Liu_at_infonet.com
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

-- 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 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Roy Ferguson</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

rferguso_at_level1.com

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

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Thu Oct 26 2000 - 15:45:44 CDT