程序员人生 网站导航

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

栏目:数据库应用时间:2015-01-29 08:53:50
在部署DataGuard时,最简单的情况是主/备节点配置完全相同的。但是,有时会碰巧会有在异构操作系统上进行部署的情况,以便于从异构平台之间进行数据迁移能有最小的停机时间或风险。为用户通过配置异构的处理能力或硬件本钱较低的备用系统,以减少在灾备上的投资,这也是全理的方案。使用提供这类配置的说明信息,以肯定哪些平台组合能进行Data Guard的配置,和任何额外的要求或限制是不是在可能适用的范围。

如果斟酌使用1个异构的主/备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⑹4 AMD64 and x86⑹4 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之外,通过下表也能够看到,1些不同的平台之间也能配置 物理 DataGuard,如Linux x86⑹4和Microsoft Windows (x86⑹4)。



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⑹4)
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⑹4
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⑹4)
13 - Oracle 11g onward 
17 - Oracle 10g onward, see Support Note: 414043.1
20

文档 ID 413484.1

总结:

也能够看到,从Oracle 11g开始, Oracle能支持某些异构平台之间的 DataGuard 部署了。



------分隔线----------------------------
------分隔线----------------------------

最新技术推荐