Re: Standby redo logs

  • From: Nassyam Basha <nassyambasha@xxxxxxxxx>
  • To: Martin Klier <usn@xxxxxxxxx>
  • Date: Thu, 31 Jul 2014 22:16:43 +0530


Realtime apply applicable only with standby redo logs.
your question might be performance variance with and without real time
apply? When you deal with maximum performance primary doesn't bother at all
whether acknowledged by network or data received and written on standby
database as simple it acts as independent database.

database performance vary for sure in maximum protection &
With maximum availability whenever standby unreachable then depending on
NET_TIMEOUT parameter it works as maximum performance mode, that mean it
depends on standby database. So there will be performance impact in both
the cases.


On Thu, Jul 31, 2014 at 10:09 PM, Martin Klier <usn@xxxxxxxxx> wrote:

> Thanks Mark for the point - sometimes a delay is the crucial point and
> argument for a standby DB.
> Is there a performance difference in Real Time Apply with or without
> Standby Redo Logs?
> Thanks
> Martin
> Am 31.07.2014 18:10, schrieb Mark W. Farnham:
> > One additional point: SOMETIMES a standby is configured with an
> > intentional lag in the application of the redo as a protection against
> > logical corruption of your database by any of programming error, hacking
> > attack, insider malfeasance, <and more than I can think of>. In that
> > case lacking standby redo logs is useful to prevent accidentally
> > starting the lagged (possibly remote) version of the database.
> --
> --
> Usn's IT Blog for Oracle and Linux
> Twitter: @MartinKlierDBA
> performing databases
> Your reliability. Our concern.

Nassyam Basha.
Oracle DBA
*The Pythian Group * <>
11g OCP Certified, Blogger
Co-Author: Oracle Data Guard 11gR2
Member of Oraworld-team <>

Visit My Blog <>
Let's Connect - Linkedin Profile <>
My Twitter <>
My Facebook <>

Other related posts: