Re: Automatic log switching in DataGuard

  • From: "Martin Bach" <development@xxxxxxxxxxxxxxxxx>
  • To: "Don Seiler" <don@xxxxxxxxx>,Amihay.Gonen@xxxxxxxxxxx
  • Date: Wed, 22 Sep 2010 10:09:18 +0100

Sorry for hijacking this thread but I just wondered if anyone was using a non 
default protection mode (other than maximum performance). With maximum 
protection for example you get near to  "zero data loss", but at the risk of 
having a production outage if the primary can't write to at least one mandatory 
destination.

I personally never bothered raising the protection level. Real time apply plus 
archive_lag_target always worked for me. Changing protection levels has been 
simplified in 11.2.

Regards,

Martin Bach

Oracle Certified Master 10g
http://martincarstenbach.wordpress.com
http://www.linkedin.com/in/martincarstenbach

----- Reply message -----
From: "Don Seiler" <don@xxxxxxxxx>
Date: Tue, Sep 21, 2010 15:30
Subject: Automatic log switching in DataGuard
To: <Amihay.Gonen@xxxxxxxxxxx>
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "Koby Nachmany" 
<Koby.Nachmany@xxxxxxxxxxx>


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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: