Re: Increase frequency of log switches

Hi,

create a new redolog-group with something like this:

alter database add logfile group 8
('<ORACLE_BASE>/oradata/<SID>/log<SID>8.ora') size 10MB

Wait till a switch, or force switch with enterprise manager. Delete inactive redolog group with EM.

hope that helps,

Toni

In article <1089292727.77473.0_at_iris.uk.clara.net>, 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
>
>
Received on Thu Jul 08 2004 - 10:15:03 CDT