Re: Automatic log switching in DataGuard

From: Don Seiler <don_at_seiler.us>
Date: Tue, 21 Sep 2010 09:30:54 -0500
Message-ID: <AANLkTinQK62gG2Rk2GxFHHopMGSaf+wm+hGtjS0u_MEd_at_mail.gmail.com>

archive_lag_target specifies the number of seconds to do automatic log switch. e.g. setting to 600 will do a log switch every 10 minutes. We use this parameter on almost all of our dataguard clients. Obviously if there is heavy redo generation, log switches will be more frequent, but archive_lag_target specifies the maximum amount of time between switches.

Don.

On Tue, Sep 21, 2010 at 9:26 AM, Amihay Gonen <Amihay.Gonen_at_ecitele.com> wrote:
> Hi DBAs,
>
>
>
> Do you know if there a option (oracle parameter ) to do automatic log
> switching for shipping to standby server in 10gR2 (or 11gR2).
>
>
>
> For example , if the SLA defined as data loss less than 20 min , then we
> need to have somehow log switch event 20min ,even if the DB is idle (log
> switch once an hour) ?
>
>
>
> Regards,
>
> Amihay Gonen,
>
> System Infra Manager
>
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 21 2010 - 09:30:54 CDT