May 3, 2011

Oracle on active-active replication

I am beginning to understand better some of the reasons that Oracle likes to review analyst publications before they go out. Notwithstanding what an Oracle executive told me Friday, I received an email from Irem Radzik of Oracle which said in part:

I am the product marketing director for Oracle GoldenGate product. We have noticed your blog post on Exadata covering a description for Active Data Guard. It refers to ADG being the “preferred way of Active-Active Oracle replication”.

I’d like to request correction on this comment as ADG does not have bidirectional replication capabilities which is required for Active-Active replication. GoldenGate is a complementary product to Active Data Guard with its bidirectional replication capabilities (as well as heterogeneous database support) and it is the preferred solution for Active-Active database replication.

Please note also a correction on product name spelling, notwithstanding that at least one Oracle person read the post before that, requested a different change, but didn’t notice that error.


6 Responses to “Oracle on active-active replication”

  1. Oracle and Exadata: Business and technical notes : DBMS 2 : DataBase Management System Services on May 3rd, 2011 9:10 pm

    […] I have no idea why I was told the following, in view of a subsequent email. Oracle Active Data Guard, first introduced in the Oracle 11g code line, is the preferred way to do […]

  2. Gera Shegalov on May 11th, 2011 8:32 pm

    Just an explanation of the term “Active” in Active Data Guard.

    ADG is an extension of the Physical Standby implementation of Data Guard. Physical Standby is a single-master replication by means of redo log streaming to remote standby sites. This is a high performance way of maintaining a physical standby copy of the primary database. It has no data type limitations (unlike Logical Standby) and has better performance and corruption protection than storage-based DR solutions. Originally customers were not able to utilize a physical standby database for anything else than DR since the standby was just mounted during redo apply.

    What makes ADG Active is that ADG allows customers to open a physical standby in read-only mode and offload read-only activities such as reporting while recovery concurrently applies redo arriving from the primary database. ADG makes sure that application see consistent snapshots.

  3. Curt Monash on May 12th, 2011 7:33 pm


    That’s Active-Active in my book, and evidently of those I met with as well. The idea that you need bi-directional replication to do Active-Active doesn’t resonate.

  4. Gera Shegalov on May 13th, 2011 3:01 am


    My previous comment was stated as an explanation of the product name rather than a contribution to your discussion about Active/Active.

    As for the discussion, my personal (not of Oracle who is my employer) academic view is that you can’t use a blanket term Active/Active for ADG because it’s not applicable for general scenarios that include updates. Compare this to RAC where you can connect to any node to run any kind of workload. RAC is an Active/Active system par excellence. (Unlike Data Guard, RAC is not designed to span long distances between data centers). Other, more heterogeneous, example of a true Active/Active system would be database systems with bi-directional replication as mentioned in the GoldenGate comment.

  5. Curt Monash on May 13th, 2011 1:17 pm


    Regarding dueling definitions of “Active-Active”, I refer you to Monash’s Third Law of Commercial Semantics: 🙂

    That aside, I appreciate your helpfulness and clarity!

    What I did not appreciate was your colleague demanding a “correction” over something other Oracle people clearly believe and indeed had just told me.

  6. Rodrigo Arias on May 16th, 2011 5:09 pm

    Hi, I want to know how to licensing Golden Gate when I have the database in 2 servers with RAC active-active, each server has 2 processors with 4 cores each one.


Leave a Reply

Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:


Search our blogs and white papers

Warning: include(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29

Warning: include( failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29

Warning: include(): Failed opening '' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/dbms2cm/public_html/wp-content/themes/monash/static_sidebar.php on line 29