当前位置：首页 -> 基础 -> 数据库编程

异构平台之间的配置DataGuard的情况说明(一)

2015-01-26 10:48:24 · 作者: · 浏览: 26
标签: 平台 之间 配置 DataGuard 情况 说明
在部署DataGuard时，最简单的情况是主/备节点配置完全相同的。但是，有时会碰巧会有在异构操作系统上进行部署的情况，以便于从异构平台之间进行数据迁移能有最小的停机时间或风险。为用户通过配置异构的处理能力或硬件成本较低的备用系统，以减少在灾备上的投资，这也是全理的方案。使用提供这种配置的说明信息，以确定哪些平台组合能进行Data Guard的配置，以及任何额外的要求或限制是否在可能适用的范围。

如果考虑使用一个异构的主/备DataGuard配置，Oracle建议用户进行充分的测试，并确保DataGuard能够实现switchover 或 failover的正常切换。

1.确定主备库的 Platform ID

SQL> select platform_id, platform_name from v$database;

PLATFORM_ID PLATFORM_NAME
----------- --------------------------------------------------------------------------------
13 Linux x86 64-bit


只要在被认证的每个服务器上能运行Oracle的平台上，安装了Oracle软件是相同的，并且是相同的Oracle 数据库版本和补丁集，主服务器和备用服务器之间的差异总是支持。
所支持的这种差异的例子包括以下内容：

  • 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 2000 and Windows XP)
    上面的差别能被认为是相同的平台（PLATFORM_ID）


    2. 如果主\备库的平台（PLATFORM_ID）不同，能通过下面的表检查两个台之间是否能支持配置物理 DataGuard


    除了支持相同的平台配置DataGuard以外，通过下表也可以看到，一些不同的平台之间也能配置 物理 DataGuard，如Linux x86-64和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 is not 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 is not 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
    11, 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
    11, 13 - Oracle 11g onward, requires Patch 13104881
    9 IBM zSeries Based Linux
    z/Linux    		 9
    18 (64-bit zSeries only)
    10 Linux (32-bit)
    Linux x86    		 7 - Oracle 11g onward, requires Patch 13104881
    10
    11, 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
    11, 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