Re: Increase frequency of log switches

On Thu, 8 Jul 2004 14:20:39 +0100, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:

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

First, if you are properly set up in archive log mode, have duplexed redo log groups, and are taking regular backups, the amount of data lost in the event of "a major machine failure" is already near zero, and has nothing to do with the frequency of log switches.

Second, the reason you don't find a parameter to control the maxsize of a redo log before a switch is because there is none. You're redo log files are a fixed size. A switch occurs when one fills up or you manually issue ALTER SYSTEM SWITCH LOGFILE. Received on Thu Jul 08 2004 - 10:16:35 CDT