Message-Id: <10661.120315@fatcity.com> From: Satar Naghshineh Date: Thu, 26 Oct 2000 10:43:25 -0700 Subject: RE: Too many archive log 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@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@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@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 RE: Too many archive log

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