RE: Too many archive log

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Thu, 26 Oct 2000 10:43:25 -0700
Message-Id: <10661.120315@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_01C03F74.3DDD2000
Content-Type: text/plain

Oh wow!

Create bigger redo logs, checkpoint them based on data if your business requirements forced you to create small redo logs. You might see performance improvements because the system will do less I/O operations.

As far as "how much days worth of data to keep" goes, I personally keep 2 backups worth of redo logs on disk. This will help me out if one of my backups are not good.

Regards,
Satar

> -----Original Message-----
> From: Larry Taylor [SMTP:ltaylor_at_iq.com]
> Sent: Thursday, October 26, 2000 6: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_01C03F74.3DDD2000
Content-Type: text/html
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>

Oh wow!

Create bigger redo = logs, checkpoint them based on data if your business requirements = forced you to create small redo logs. You might see performance = improvements because the system will do less I/O operations.

As far as "how = much days worth of data to keep" goes, I personally keep 2 backups = worth of redo logs on disk. This will help me out if one of my backups = are not good.

Regards, Satar

</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">Larry Taylor [SMTP:ltaylor_at_iq.com]</FONT>

Sent:   Thursday, October 26, 2000 6: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.

<BR><FONT SIZE=3D2 FACE=3D"Arial">Each members size is 1 meg each. =
</FONT>
</P>

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

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 = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = to be removed from).  You may Received on Thu Oct 26 2000 - 12:43:25 CDT