Irrelevant thoughts of an oracle DBA

20 October 2009

Multiple standby databases and supplemental logging

Filed under: dataguard,infrastructure — Freek D'Hooge @ 18:10

A quick warning:

When you setup a logical standby database, you need to activate supplemental logging on the primary database.
This is done automatically when you build the data dictionary (by running the procedure).
Activating supplemental logging is however (I know now) a control file change and is thus not replicated to the other physical standby databases.
As a result, the logical standby will become (logical) corrupt when you perform a role switch between your primary and another physical standby database.

I learned this the hard way  :(
Luckily it was during a proof of concept and not in a real production environment … .

Of course, AFTERWARDS, I found the following maa document which points out that you have to enable supplemental logging yourself on the other physical standby databases.
It still makes a good read though


  1. Oooh! Thanks for sharing. Thats a very useful tip.

    Comment by prodlife — 20 October 2009 @ 23:32 | Reply

  2. Hi,

    Learn by hard way is the one biggest experience.

    Comment by dbametrix — 22 October 2009 @ 21:18 | Reply

    • Yep, not likely I will forget this the next time :)

      Comment by dhoogfr — 23 October 2009 @ 22:58 | Reply

  3. […] Freek D’Hooge -Multiple standby databases and supplemental logging […]

    Pingback by Blogroll Report 16/10/2009-23/10/2009 « Coskan’s Approach to Oracle — 27 October 2009 @ 1:55 | Reply

  4. Thanks! Made a small case in my mind to store and keep this information.

    Comment by Bernard Polarski — 28 October 2009 @ 16:55 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: