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.

migration.jpg

One example of heterogenous 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 11.2.0.2 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 heterogenous 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!

Comments:

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 ! Thanks! Thy

Posted by Thy on May 25, 2011 at 04:05 PM CEST #

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.

Posted by Roy on May 25, 2011 at 08:08 PM CEST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers