Re: Increase frequency of log switches

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 08 Jul 2004 15:13:13 GMT
Message-ID: <dwdHc.191$ju1.32@nwrddc04.gnilink.net>

"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message news:1089292727.77473.0_at_iris.uk.clara.net...
> Hi,
>
> RHEL 3
> 9.2.0.4
>
> At the moment i get archive redo logs generated that are 100meg in size which is slightly more
frequent than 1 per day. As i'd like
> to be able to reduce to a minimum the data lost in the event of major machine failure how can i
increase the frequency of these
> switches. I don't really see anywhere in the spfile where i set the maxsize of a redo log before a
switch.
>
> Am i missing something? so far google has not come up with this one.
>
> thanks
>
>

You might want to check out the init param archive_lag_target Look in doco and/or google for it.

Also: http://www.oracledba.co.uk/tips/9i_archive_lag.htm

Anurag Received on Thu Jul 08 2004 - 10:13:13 CDT