When deploying Dataguard, the simplest scenario is that the primary/standby node configuration is identical. However, there are times when deployments can happen on heterogeneous operating systems to allow for minimal downtime or risk of data migration from heterogeneous platforms. It is also a complete solution for users to reduce their investment in disaster preparedness by configuring heterogeneous processing power or a backup system with lower hardware costs. Use the descriptive information that provides this configuration to determine which platform combinations can be configured for data guard, and whether any additional requirements or restrictions are within the scope that may apply.
If you consider using a heterogeneous master/standby Dataguard configuration, Oracle recommends that users perform adequate testing and ensure that Dataguard is able to achieve normal switchover switchover or failover.
1. Determine the Platform ID of the Master repository
Sql> Select platform_id, platform_name from V$database;
platform_id Platform_name
----------- --------------------------------------------------------------------------------
Linux x86 64-bit
As long as the Oracle software is installed on a platform that is capable of running on each of the certified servers, the same Oracle database version and patch set, and the differences between the primary and standby servers are always supported.
Examples of such differences that are supported include the following:
- Hardware manufacturer (e.g. Dell and Sun or Hitachi and EMC)
- Hardware configuration (e.g. number of CPUs, amount of RAM, storage configuration, etc)
- Processor (e.g. x86-64 AMD64 and x86-64 Intel 64; POWER4 and POWER5)
- Operating system distribution (e.g. Red Hat Linux, SUSE Linux or Oracle Enterprise Linux)
- Operating system version (e.g. Windows $ and Windows XP)
The above differences can be thought of as the same platform (PLATFORM_ID)
2. If the main \ Standby platform (platform_id) is different, the following table can be checked to see whether the configuration of physical DataGuard can be supported between two units
In addition to supporting the same platform configuration DataGuard, you can see from the following table that physical DataGuard can also be configured between different platforms, such as Linux x86-64 and Microsoft Windows (x86-64).
platform_id |
Platform_name Release Name |
Platform_ids supported within the same data guard configuration when using Data guard Redo Apply (physical Standby) |
2 |
SOLARIS[TM] OE (64-bit) Solaris Operating System (SPARC) (64-bit) |
2 6-this isn't supported due to issues reported in Bug 12702521 |
3 |
HP-UX (64-BIT) HP-UX Pa-risc |
3 4-oracle 10g onward, see Support note:395982.1 and note:414043.1 |
4 |
HP-UX IA (64-bit) HP-UX Itanium |
4 3-oracle 10g onward, see Support Notes note:395982.1 and note:414043.1 |
5 |
HP Tru64 UNIX HP Tru64 UNIX |
5 |
6 |
IBM AIX on POWER Systems (64-bit) |
2-this isn't supported due to issues reported in Bug 12702521 6 |
7 |
Microsoft Windows (32-bit) Microsoft Windows (x86) |
7 8, 12-oracle 10g onward, see Support note:414043.1 10-oracle 11g onward, requires Patch 13104881 One, 13-oracle 11g onward, see Support note:414043.1, also requires Patch 13104881 |
8 |
Microsoft Windows IA (64-bit) Microsoft Windows (64-bit Itanium) |
7-oracle 10g onward, see Support note:414043.1 8 12-oracle 10g onward One, 13-oracle 11g onward, requires Patch 13104881 |
9 |
IBM zSeries Based Linux Z/linux |
9 (64-bit zSeries only) |
10 |
Linux (32-bit) Linux x86 |
7-oracle 11g onward, requires Patch 13104881 10 One, 13-oracle 10g onward, see Support note:414043.1 |
11 |
Linux IA (64-bit) Linux Itanium |
10-oracle 10g onward, see Support note:414043.1 11 13-oracle 10g onward 7-oracle 11g onward, see Support note:414043.1, also requires Patch 13104881 8, 12-oracle 11g onward, requires Patch 13104881 |
12 |
Microsoft Windows 64-bit for AMD Microsoft Windows (x86-64) |
7-oracle 10g onward, see Support Note note:414043.1 8-oracle 10g onward 12 One, 13-oracle 11g onward, requires Patch 13104881 |
13 |
Linux 64-bit for AMD Linux x86-64 |
7-oracle 11g onward, see Support note:414043.1, also requires Patch 13104881 10-oracle 10g onward, see Support Note note:414043.1 11-oracle 10g onward 8, 12-oracle 11g onward, requires Patch 13104881 13 20-oracle 11g onward |
15 |
HP Open VMS HP OpenVMS Alpha HP IA OpenVMS OpenVMS Itanium |
15 |
16 |
Apple Mac OS Mac OS X Server |
16 |
17 |
Solaris Operating System (x86) Solaris Operating System (x86) |
17 20-oracle 10g onward, see Support note:414043.1 |
18 |
IBM Power Based Linux Linux on Power |
9 (64-bit zSeries only) 18 |
20 |
Solaris Operating System (AMD64) Solaris Operating System (x86-64) |
13-oracle 11g onward 17-oracle 10g onward, see Support note:414043.1 20 |
Document ID 413484.1
Summarize:
You can also see that Oracle can support DataGuard deployment between some heterogeneous platforms, starting with Oracle 11g.
Configuration Dataguard between heterogeneous platforms description of the situation