This discussion is archived
9 Replies Latest reply: Jan 29, 2013 9:46 AM by Sebastian Solbach (DBA Community) RSS

Data Guard versus Active Data Guard?

garywicke Newbie
Currently Being Moderated
Environment:

Oracle Database 11.2.0.3 EE on Solaris 5.10

I've read several threads here and poured through the documentation but this point still escapes me.

When does Data Guard turn into Active Data Guard?

Is it when the Standby is OPEN and in READONLY mode while redo logs are being actively applied?

If I stop log apply and OPEN the Standby for READONLY access, is that just regular Data Guard?

I obviously want to use Data Guard but not pay for Active Data Guard at this point.

Where is this documented?

Michael, if you're listening, this is right up your alley! :-)

Thanks very much!!

-gary
  • 1. Re: Data Guard versus Active Data Guard?
    mseberg Guru
    Currently Being Moderated
    Hello;

    When a Standby database is open Read-only for queries, sorting, and reporting.

    Requires a License.

    The Standby still applies redo.

    http://www.oracle.com/technetwork/database/features/availability/ds-activedataguard-11gr2-130305.pdf

    Also see - 9.2 Opening a Physical Standby Database - in

    Oracle® Data Guard Concepts and Administration 11g Release 2 (11.2) E10700-02


    Best Regards

    mseberg

    Edited by: mseberg on Jan 29, 2013 8:03 AM
  • 2. Re: Data Guard versus Active Data Guard?
    CKPT Guru
    Currently Being Moderated
    Oracle Database 11.2.0.3 EE on Solaris 5.10

    I've read several threads here and poured through the documentation but this point still escapes me.

    When does Data Guard turn into Active Data Guard?
    If you OPEN database from MOUNT status. But you should have license to use feature of ADG(Active Data Guard)
    Is it when the Standby is OPEN and in READONLY mode while redo logs are being actively applied?
    Yes, It can perform both tasks 1) Recovery 2) Read-Only Options
    If I stop log apply and OPEN the Standby for READONLY access, is that just regular Data Guard?
    No, Your standby will not synchronized with primary. It is just readonly and LAG with primary.
    I obviously want to use Data Guard but not pay for Active Data Guard at this point.
    Then put in MOUNT status and you cannot run any SELECT(Read-only) queries. :)
    Where is this documented?
    You can refer features of Active Data Guard http://www.oracle.com/technetwork/database/features/availability/ds-activedataguard-11gr2-130305.pdf
    Michael, if you're listening, this is right up your alley! :-)
    Yes, he is listening ;)

    I didn't checked Mseberg comments, There is 1 minute of lag between Me and Mseberg :P

    Edited by: CKPT on Jan 29, 2013 7:32 PM
  • 3. Re: Data Guard versus Active Data Guard?
    garywicke Newbie
    Currently Being Moderated
    Thanks very much guys!

    I wish there was a way to assign 2 'CORRECT' answers. I had to give this one to Michael only because he slipped in there first but obviously both of you nailed it.

    I'll go back and check the document references.

    Just to clarify, if I stop log apply ( I know there will be a lag now from Primary ) and OPEN the Standby in READONLY mode, does that invoke the Active Data Guard license?

    If I wanted to create say a 1 hour window where people could run queries against the Standby and then restart the log apply later (back in MOUNT mode) to re-sync with the Primary, is there a way to do that without invoking Active Data Guard?

    You guys rock!!

    -gary
  • 4. Re: Data Guard versus Active Data Guard?
    Shivananda Rao Guru
    Currently Being Moderated
    Hello,

    When the standby database is opened in read only mode and is not under recovery stage, then it isn't an active dataguard.
    You can have it opened in read only mode and allow users to access the standby database. But, recovery would be not be taking place.


    Regards,
    Shivananda
  • 5. Re: Data Guard versus Active Data Guard?
    mseberg Guru
    Currently Being Moderated
    Hello;
     OPEN the Standby in READONLY mode, does that invoke the Active Data Guard license?
    My opinion is no since Data Guard would not be "Active" I believe Its OK. But only Oracle's answer really counts.

    I don't have a document to support this answer. But this may help :

    Re: Active Data Guard License is technical or legal ?

    The other option is Logical Standby. This would allow what you want without License costs. The downside is you lose an exact copy of your Primary or have to cascade from the physical standby.

    Best Regards

    mseberg

    Edited by: mseberg on Jan 29, 2013 8:48 AM

    Edited by: mseberg on Jan 29, 2013 9:00 AM
  • 6. Re: Data Guard versus Active Data Guard?
    garywicke Newbie
    Currently Being Moderated
    Thanks Shivananda and Michael

    I think I've got a handle on it now.

    Maybe the docs aren't very explicit so people accidentally start using the ADG features and end up paying for the option. But, Oracle wouldn't do that, would they?? :-)

    Thanks again for all your help.

    -gary
  • 7. Re: Data Guard versus Active Data Guard?
    986735 Newbie
    Currently Being Moderated
    If you are even considering Active DG then do yourself a favor and check out Shareplex for Oracle. Better product, more flexibility to do more things ADG cannot do at a more consumer friendly cost.

    ADG is nothing more than Oracle charging you money for something you already have up and running in Data Guard.
  • 8. Re: Data Guard versus Active Data Guard?
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi msberg,

    If the user makes sure ADG is not used, then there is no license issue:
    http://docs.oracle.com/cd/E11882_01/license.112/e10594/options.htm#CJADECHA

    Hi user6296186,

    before missusing the Oracle forums to promote another product, think about what you are writing. Shareplex is a technology comparable with GoldenGate and not with Data Guard (or Active Data Guard).
    While GoldenGate and Shareplex definitely have their advantages while doing DB upgrades etc, Physical Data Guard (and with this Active Data Guard) is build for disaster recovery, in which area it by far exceeds any possibility you have with other products:

    => Does Shareplex provide Automatic Block repair?
    This is one of the greatest features of ADG, since it will automatically detect a corrupt block on the primary or standby site, and instead of giving back an ORA-600 to the user doing a query, it will automatically repair the block in the background.
    => Does Shareplex support all Data Types like the Anytype or any other Object Relational data type (e.g. Media Types, Spatial Data Types, just to name a few)? ADG does.
    => Does Shareplex allow a backup of the Standby and the restore of the primary with it? ADG is physical Data Guard and is 100% block identical to the primary. And with ADG you even get fast incremental backups on the Standby site.
    => And by far the most important: Do you get any support from Oracle if your primary fails, and your Standby setup via. Shareplex does not work?

    ADG provides a lot of add on feature you don't have with a standard Data Guard environment.

    Regards
    Sebastian
  • 9. Re: Data Guard versus Active Data Guard?
    Sebastian Solbach (DBA Community) Guru
    Currently Being Moderated
    Hi,

    forgot the most important point:

    How difficult is it to setup Active Data Guard?
    => Simply issue an "alter database open" in the Standby system. If you have Data Guard Broker in use, he handles the other 2 necessary steps (stop the MRP and restart the MRP) for you in the background.

    Now compare that to setup GG or Shareplex.....

    Regards
    Sebastian

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points