Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Too many archive log

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>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Oh wow! </FONT> </P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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.</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">As far as &quot;how = much days worth of data to keep&quot; 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.</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR> 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">Larry Taylor [SMTP:ltaylor_at_iq.com]</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Thursday, October 26, 2000 6:25 PM</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>= </B> <FONT SIZE=3D1 FACE=3D"Arial">Too many archive log</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi all,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">My database has 2 redo log groups and = each group has 3 members.</FONT>

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

<P><FONT SIZE=3D2 FACE=3D"Arial">The problem is that archive logs are = generated at a fast rate:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:21 0000091001.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:21 0000091002.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:21 0000091003.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:22 0000091004.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:22 0000091005.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1050112 Oct 23 = 19:22 0000091006.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:22 0000091007.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:23 0000091008.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:23 0000091009.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1052672 Oct 23 = 19:23 0000091010.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:23 0000091011.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056256 Oct 23 = 19:24 0000091012.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:24 0000091013.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 = oracle&nbsp;&nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 = 19:24 0000091014.arc</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-rw-r-----&nbsp;&nbsp; 1 oracle&nbsp;&= nbsp; dba&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1056768 Oct 23 19:24 = 0000091015.arc</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Isnt it good practice to keep 3 days = worth of archive logs on disk</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">in case needed? If so, what is the = best solutions for this high rate </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">logs being generated so often?</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks in advance.</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L = FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>

<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>

<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network = Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) = 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
-----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">To REMOVE yourself from this mailing = list, send an E-Mail message</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the message BODY, include a line = containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(or the name of mailing list you want = to be removed from).&nbsp; You may</FONT> Received on Thu Oct 26 2000 - 12:43:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US