RE: Too many archive log

That is why we mirror on the online redo log files.

Winnie

Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>@fatcity.com = on
10/26/2000 03:00:55 PM

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:

Subject: RE: Too many archive log

Two words Roy..=A0 Check Point=A0=A0 ;)

Satar

   -----Original Message-----
   From:=A0=A0 Roy Ferguson [SMTP:rferguso_at_level1.com]    Sent:=A0=A0 Thursday, October 26, 2000 8:52 PM    To:=A0=A0=A0=A0 Multiple recipients of list ORACLE-L    Subject:=A0=A0=A0=A0=A0=A0=A0 Re: Too many archive log

   Winnie,

   just curious, but what are the recovery issues if you are only switc= hing

   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 A=
M

>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by:=A0 root_at_fatcity.com
>
>
> To:=A0=A0 Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.c=
om>

> 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-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:21 0000091001.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:21 0000091002.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:21 0000091003.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:22 0000091004.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:22 0000091005.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1050112 Oct 23 =
19:22 0000091006.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:22 0000091007.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:23 0000091008.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:23 0000091009.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1052672 Oct 23 =
19:23 0000091010.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:23 0000091011.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056256 Oct 23 =
19:24 0000091012.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:24 0000091013.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 1056768 Oct 23 =
19:24 0000091014.arc

> -rw-r-----=A0=A0 1 oracle=A0=A0 dba=A0=A0=A0=A0=A0 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 ra=
te

> logs being generated so often?
>
> Thanks in advance.
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
>=A0=A0 INET: ltaylor_at_iq.com
>
> Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858)=
 538-5051
> San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet acce=
ss / 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 i=

n


   > the message BODY, include a line containing: UNSUB ORACLE-L

   > (or the name of mailing list you want to be removed from).=A0 You =

may


   > also send the HELP command for other information (like subscribing=

).


   >

   >

   >

   > --

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

   > --

   > Author:

   >=A0=A0 INET: Winnie_Liu_at_infonet.com

   >

   > Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858)=

 538-5051


   > San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet acce=

ss / 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 i=

n


   > the message BODY, include a line containing: UNSUB ORACLE-L

   > (or the name of mailing list you want to be removed from).=A0 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
   =A0 INET: rferguso_at_level1.com

   Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) 5=
38-5051
   San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- 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