Cross-Platform Migration using Heterogeneous Data Guard

Most people think of Data Guard as a disaster recovery solution, and it certainly excels in that role. However, did you know that you can also use Data Guard for platform migration under some conditions?

While you would normally have your primary and standby Data Guard systems running on the same OS and hardware platform, there are some heterogeneous combinations of primary and stanby system that are supported by Data Guard Physical Standby.


One example of heterogeneous Data Guard support is the ability to go between Linux and Windows on many processor architectures. Another is the support for environments that are running HP-UX on both PA-RIsC and Itanium hardware. Brand new in is the ability to have both SPARC Solaris and IBM AIX on Power Systems in the same Data Guard environment. See My Oracle Support note 413484.1 for all the details about supported platform combinations.

So, why mention this in an upgrade blog? Simple: much of the time required for a platform migration is usually spent copying files from one system to another. If you are moving between systems that are supported by heterogeneous Data Guard, then you can reduce that migration downtime to a matter of minutes. This can be a big win when downtime is at a premium (and isn’t downtime always at a premium? In addition, you get the benefit of being able to keep the old and new environments synchronized until you are sure the migration is successful!

A great case study of using Data Guard for a technology refresh is located on this OTN page. The case study showing CERN’s methodology isn’t highlighted as a link on the overview page, but it is clickable.

As always, make sure you are fully versed on the details and restrictions by reading the available documentation and MOS notes. Happy migrating!

2 thoughts on “Cross-Platform Migration using Heterogeneous Data Guard

  1. Hi ,
    We are migrating E-biz R12 to itanium platform from RISC. Wondering wheather we can utilize data guard to minimize downtime ? is it possible?
    Your help much appriciated !

  2. It may very well be possible to use heterogeneous data guard to minimize downtime for such a migration. The key is to look at MOS note 1079563.1, which gives the version numbers for which RMAN is able to instantiate a physical standby cross-platform.
    In the case of the PA-RISC to Itanium pair, your database would need to have been CREATED as Oracle Database 10g Release 2 or later. As note 1079563.1 says, if the database was created with an earlier version and upgraded to 10.2 or later, then an RMAN CONVERT is still required — which means that heterogeneous data guard would not work.

Leave a Reply

Your email address will not be published. Required fields are marked *