合 Oracle DG（Data Guard）支持异构平台说明

一.说明

OracleData Guard 最简单的配置是主备库的环境都一样，但是在有些情况下需要异构的配置，比如在迁移时为了减少停机时间或者零停机，可能就需要使用异构的DG 配置。

关于Oralce DataGuard 异构平台的搭建，MOS上有2篇文章专门来说明：

Data Guard Support for HeterogeneousPrimary and Logical Standbys in Same Data Guard Configuration [ID 1085687.1]

Data Guard Support for HeterogeneousPrimary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]

Prior to DataGuard 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. Thisrestriction is lifted from Data Guard 11g onward.

--在Oracle 11g 之前，DG Broker 不支持不同word-size的DG 配置，因此需要修改word-size. 到了Oracle 11g 之后，DG 就没有了这个限制。

Changing between 32-bit and 64-bit WordSizes [ID 62290.1]

这里的word-size 只的是数据库的位数，是32位还是64位。其查看方法，我之前的Blog 有说明。

查看Oracle 是32位还是64位的方法

http://blog.csdn.net/tianlesoftware/article/details/6818709

在配置异构DG 之前，要先查看主备库的Platform. ID,可以从v$database 视图中查看：

SQL> select platform_id,platform_name from v$database;

PLATFORM_ID PLATFORM_NAME

7 Microsoft Windows IA (32-bit)

SQL> select platform_id,platform_name from v$database;

PLATFORM_ID PLATFORM_NAME

-------------------------------------------------------------------------------

10 Linux IA (32-bit)

这里的Platform_ID 是唯一的，不同的平台，即OS 对应一个ID。

Differencesbetween the primary server(s) and the standby server(s) are always supported aslong as the Oracle software installed on all servers is of the same OraclePlatform. as defined above, is certified to run on each server, and is the sameOracle Database Release and Patch Set. Examples of such differences that aresupported include the following:

--只要server 上Oracle 的软件的版本和位数是一致的，主备库就支持不同的server，即OS 不影响，比如：

（1）Hardware manufacturer (e.g. Delland Sun or Hitachi and EMC)

（2）Hardware configuration (e.g. numberof CPUs, amount of RAM, storage configuration, etc)

（3）Processor (e.g. x86-64 AMD64 andx86-64 Intel 64; POWER4 and POWER5)

（4）Operating system distribution (e.g.Red Hat Linux, SUSE Linux or Oracle Enterprise Linux)

（5）Operating system version (e.g.Windows 2000 and Windows XP)

二.物理standby

In addition togeneral support when using the same Oracle platform, Data Guard Redo Apply(physical standby) can support specific mixed Oracle Platformcombinations. Oracle Platform. IDs, platform. names, and which combinationsof platform. ID(s) that can be combined to form. a supported Data Guardconfiguration using Redo Apply are listed in the table below. Platformcombinations not listed in the table below are not supported using Data GuardRedo Apply.

--物理standby 支持的混合平台如下表所列，不在下表不受支持。

Table Notes –表格注释

(1) Prior to Data Guard 11g, theData Guard Broker did not support different word-size in the same Data Guardconfiguration, thus requiring management from the SQL*Plus command line formixed word-size Data Guard configurations. This restriction is lifted fromData Guard 11g onward.

--在Oracle 11g之后，不受数据库word-size的限制（数据库32还是64位）

(2) Both primary and standbydatabases must be set at the same compatibility mode as the minimum release (ifspecified) in the table below.

--在下表所列的平台中，主备库的compatible 参数必须相同。

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。