Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

I read My Oracle Support note “Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]” .
I made decision that let me check this.Then I have create two virtual machines with Oracle Virtual Box. Witch is a virtual machine OS Oracle Linux server 6.2 (x86_64) and a Virtual Machine with OS Microsoft Windows 2008 Server R2 (x64) . Installed Oracle Database 11g Release 2 ( both server, and a database (ADMDB) is created on first server.

I used RMAN Duplicate command for creation of standby database and after creation of standby  database used Data Guard Manager Command-Line interface for creation of data guard configuration.
I think about that I achieved this, this will be for all oracle database administrators very interesting.

[ID 413484.1]

The simplest path when deploying Data Guard is to configure a homogeneous and symmetric primary/standby configuration.  However, it is often useful to deploy a heterogeneous configuration either to utilize existing servers that happen to run different operating systems or to facilitate migrations from one platform to another with minimal downtime or risk. It is also reasonable for users to wish to reduce their disaster recovery investment by purposely configuring a standby system with less processing capacity than production, or by utilizing lower cost components than used for their primary system. 
Prior to Data Guard 11g, the Data Guard Broker did not support different word-size in the same Data Guard configuration, thus requiring management from the SQL*Plus command line for mixed word-size Data Guard configurations.  This restriction is lifted from Data Guard 11g onward.
RMAN generally supports instantiation of a physical standby database for the supported platform combinations. Please see Support Note 1079563.1 for details.
Enterprise Manager can not be used for standby database creation or other administrative functions in any configuration where PLATFORM_IDs are not identical. Oracle recommends using the Data Guard Broker command line interface (DGMGRL) to administer mixed platform combinations from Oracle Database 11g onward and SQL*Plus command line for configurations that pre-date Oracle Database 11g.

Platform name
 Release name
Platform name supported within the same Data Guard configuration when using Data Guard Redo Apply
(Physical Standby)
Linux 64-bit for AMD
Linux x86-64
Microsoft Windows 64-bit for AMD
Microsoft Windows (x86-64) - Oracle 11g onward, requires patch for Bug 13104881

Mahir M. Quluzade


  1. Saw couple of links with step by step procedures, you are one more step ahead with video tutorial on (Heterogeneous dataguard) nice demonstration. Its very detailed and much useful. Thanks for sharing. Good Job. :)

  2. I'm very glad, you are visit my blog, you are like my video and many thanks for nice comment my friend Nassyam Basha (CKPT)!

    Mahir M. Quluzade

    1. Really Super Demonstration of this Datagurad vido..really good effert Quluzade thanks a lot for sharing this information ..Can you provide logical standby

  3. Hi Mahir,

    Good Demonstration. Really Good Efforts.

    Thanks a lot.

  4. Hi OCM Ravi!

    Thanks for your comment.


  5. Hi Mahir,

    Really good efforts..Thanks...


  6. Can I configure Data guard in my laptop by creating two oracle home?????


    1. Hi Imran!

      Don't need two oracle home, you can create two or more database on running a oracle home.

      Watch video :

      There first standby database, creating on localhost. It means priamry and standby databases runing same machine .


    2. Thanks to response Mahir..............
      Mahir I have two oracle home running there, PROD & TEST on seperate drive. How can I configure primary & second standby database running in Window platform?


    3. Can I downgrade database from to in window platform? And what are the steps to conduct.....


    4. Hi Imran and Ahmet !

      Imran : Yes you can create standby database for PROD or TEST database. I think you have running 2 database.

      Ahmet : Yes you can downgrade database. why you need downgrade, I really don't know. I think, you must see: http://docs.oracle.com/cd/E24693_01/server.11203/e23633/downgrade.htm

      Many thanks
      Mahir M. Quluzade

  7. Good demonstration Mahir..

    Shivananda Rao


Post a Comment

Popular posts from this blog

Which device is mapped Oracle ASM disk?

OTN Article: Oracle Database 12c In-Memory (Part I, II - Spanish / Portuguese)

Oracle Database 18c - Install On-Premises for Linux