Message-Id: <10661.120320@fatcity.com> From: Roy Ferguson Date: Thu, 26 Oct 2000 11:47:51 -0700 Subject: Re: Too many archive log Winnie, just curious, but what are the recovery issues if you are only switching 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 @fatcity.com on 10/26/2000 10:25:28 AM > > Please respond to ORACLE-L@fatcity.com > > Sent by: root@fatcity.com > > > To: Multiple recipients of list ORACLE-L > 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----- 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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: Winnie_Liu@infonet.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