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