RE: Too many archive log

From: Javier Morales <Javier_at_infojobs.net>
Date: Fri, 27 Oct 2000 10:27:36 +0200
Message-Id: <10662.120397@fatcity.com>

I agree...
... but maybe it would be usefull to grow up redo files a bit...

I mean, It's not only the recovery issues what makes the desition of = one
size from another... It's also the kind of management of data (oltp, = dss...)
... or simply the solution is making storage to a safe place...

and, if I remember, the question was about having 3 days of archive = redo for
a recovery...
... I'm only worried about the kind of backup... If physicaly backups = are
made everyday, 3 days of redo saved are enough ;-))

Javier Morales - javier_at_infojobs.net
Administraci=F3n Bases de Datos Oracle - InfoJobs.net Tel. +34 902 10 60 90 Ext. 2067
Fax. +34 (93) 580 56 60
=20

-----Mensaje original-----
De: Roy Ferguson [mailto:rferguso_at_level1.com] Enviado el: jueves 26 de octubre de 2000 21:52 Para: Multiple recipients of list ORACLE-L Asunto: Re: Too many archive log

Winnie,

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

Roy

>=20
>=20
>=20

> Gee.. 1MB redolog file is WAY too small!! You should definitely =
increased
> the size of the redo log.

>=20
> 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.

>=20

> Winnie

>=20
>=20
>=20
>=20
>=20

> Larry Taylor <ltaylor_at_iq.com>@fatcity.com on 10/26/2000 10:25:28 AM

>=20

> Please respond to ORACLE-L_at_fatcity.com

>=20

> Sent by: root_at_fatcity.com

>=20
>=20

> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:

>=20
>=20
>=20

> Hi all,

>=20

> My database has 2 redo log groups and each group has 3 members.
> Each members size is 1 meg each.

>=20

> The problem is that archive logs are generated at a fast rate:

>=20


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

>=20

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

>=20

> Thanks in advance.

>=20
>=20

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Larry Taylor
> INET: ltaylor_at_iq.com

>=20


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

>=20
>=20
>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author:=20
> INET: Winnie_Liu_at_infonet.com

>=20


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

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
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 Received on Fri Oct 27 2000 - 03:27:36 CDT