设为首页 收藏本站
查看: 606|回复: 0

[经验分享] Oracle Data Guard 支持的异构平台 说明

[复制链接]

尚未签到

发表于 2016-7-31 10:47:40 | 显示全部楼层 |阅读模式
  

  
一.说明
  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 thesame 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 参数必须相同。
  (3)A standby database cannot beopen read-only in any environment that has binary-level PL/SQL-relatedincompatibilities between primary and standby databases. Support Note414043.1 is referenced in the table below for any platform combinations wherethis is the case (the note provides instructions for eliminatingincompatibilities post role transition). It is possible to access astandby database in such environments in Oracle Database 11g by temporarilyconverting it to aSnapshotStandbydatabase, or in Oracle Database 10g by opening the standbyread/write as described in the Data Guard 10g Concepts and Administrationguide:Usinga Physical Standby Database for Read/Write Testing and Reporting. Bothprocedures require following the steps in note 414043.1 before making thedatabase available to users.
  
  (4)Please be sure to read SupportNotes when referenced in the table below.
  (5)RMAN generally supportsinstantiation of a physical standby database for the supported platformcombinations. Please see Support Note 1079563.1 for details.
  (6)Platforms in a supportedcombination may operate in either the primary or standby role.
  --平台支持主备库角色的转换
  (7)Enterprise Manager can not beused for standby database creation or other administrative functions in anyconfiguration where PLATFORM_IDs are not identical. Oracle recommends using theData Guard Broker command line interface (DGMGRL) to administer mixed platformcombinations from Oracle Database 11g onward and SQL*Plus command line forconfigurations that pre-date Oracle Database 11g.
  --在PLATFORM_ID 不一样的情况下,备库不能创建和使用EM。但可以使用DG Broker。
  
  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 Notes 395982.1 and 414043.1
  4
  HP-UX IA (64-bit)
  HP-UX Itanium
  4
  3 - Oracle 10g onward, see Support Notes 395982.1 and 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 for Bug 13104881
  11, 13 - Oracle 11g onward, see Support Note 414043.1, also requires patch  for Bug 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 for Bug 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 for Bug 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 for Bug  13104881
  8, 12 - Oracle 11g onward, requires patch for Bug 13104881
  12
  Microsoft Windows 64-bit for AMD
  Microsoft Windows (x86-64)
  7 - Oracle 10g onward, see Support Note414043.1
  8 - Oracle 10g onward
  12
  11, 13 - Oracle 11g onward, requires patch for Bug 13104881
  13
  Linux 64-bit for AMD
  Linux x86-64
  7 - Oracle 11g onward, see Support Note 414043.1, also requires  patch for Bug 13104881
  10 - Oracle 10g onward, see Support Note414043.1
  11 - Oracle 10g onward
  8, 12 - Oracle 11g onward, requires patch for Bug 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
  
  对表格查看的解释,这里举一例,假设准备搭建一个物理DG:
  主库:7(platform id) Microsoft Windows IA (32-bit)
  备库:10 (platform id) Linux IA (32-bit)
  
  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 for Bug 13104881
  11, 13 - Oracle 11g onward, see Support Note 414043.1, also requires patch  for Bug 13104881
  
  从这里可以看出,7支持的备库有7,8,12,10,11,13. 但是不同的版本也有限制。 我们的备库要用10,那么只能是Oracle 11g 以后才支持,并且还需要修复13104881的bug。
  
  
  
Additional information:
  
  Transient Logical Database Rolling Upgrades:Beginning withOracle Database 11.1.0.7, a physical standby database can be used to execute arolling database upgrade to a new Oracle Patch Set or database release by usingthe transient logical rolling database upgrade process. See the MaximumAvailability Architecture Best Practice paper, "Rolling Database Upgrades for PhysicalStandby Databases using Transient Logical Standby 11g". Thedatabase rolling upgrade process enables a standby database to apply redo sentby a primary database that is operating at a previous Oracle release orpatchset. The transient logical rolling upgrade process requires that theprimary and standby platform combination be a supported configuration for bothRedo Apply (see table above) and SQL Apply (see Support Note 1085687.1) as ofthe pre-upgrade Oracle release deployed in the Data Guard configuration.

DataGuard Configurations that Include a Combination of Physical and Logical StandbyDatabases:
A Data Guardconfiguration includes a primary database and up to 30 standby databases.These standby databases may be a mix of physical and logical standby databases.All physical standby databases within a single Data Guard configuration mustadhere to the requirements described in this note. Likewise, if theconfiguration includes logical standby databases, they must conform to therequirements of Support Note 1085687.1.

Real Application Cluster &Automatic Storage Management:It isnot necessary that the primary and the standby both be Oracle RAC databases, orboth use ASM. For example, the primary database may be running Oracle RAC withor without ASM, and the standby database(s) may be single-instance, with orwithout ASM. Also, in case both the primary and standby are Oracle RACdatabases, the number of Oracle RAC nodes between the primary and standbydatabases may vary. Furthermore, the versions of ASM and CRS do not need to bethe same between the primary and standby systems.

ExadataDatabase Machine: It istransparent to Data Guard whether primary and/or standby databases reside on anExadata Database Machine or on other hardware, as long as the platform ID's ofprimary and standby systems within the same Data Guard configuration conform tothe support requirements defined in the above table. If Exadata HybridColumnar Compression (EHCC) is used, it is strongly recommended that bothprimary and standby databases reside on Exadata. See the Maximum AvailabilityArchitecture Best Practice paper, "Disaster Recovery for Exadata Database Machine".
  
三.逻辑standby
  In addition togeneral support when using thesame Oracle platform, Data Guard SQL Apply(logical standby) can support specific mixed Oracle Platform combinations as ofOracle Database 11g. Oracle Platform IDs, platform names, and whichcombinations of platform ID(s) that can be combined to form a supported DataGuard configuration using SQL Apply are listed in the table below.Platform combinations not listed in the table below are not supported usingData Guard SQL Apply.
  --逻辑standby 支持如下的平台
  
  Table Notes – 表格注释
  (1)All mixed platform combinationsfor SQL Apply in the table below are supported from Oracle Database 11g onward.
  (2)Prior to Data Guard Broker 11g,the Data Guard Broker did not support different word-size in the same DataGuard configuration, thus requiring all management from the SQL*Plus commandline. This restriction is lifted from Data Guard 11g onward.
  (3)Both primary and standbydatabases must be set at the same compatibility mode as the minimum release (ifspecified) in the table below.
  (4)Please be sure to read SupportNotes when referenced in the table below.
  (5)RMAN generally supportsinstantiation of a physical standby database for the supported platformcombinations. Please see Support Note 1079563.1 for details.
  (6)Platforms in a supportedcombination may operate in either the primary or standby role unless otherwisespecified.
  (7)Enterprise Manager can not beused for standby database creation or other administrative functions in anyconfiguration where PLATFORM_IDs are not identical. Oracle recommends using theData Guard Broker command line interface (DGMGRL) to administer mixed platformcombinations from Oracle Database 11g onward and SQL*Plus command line forconfigurations that pre-date Oracle Database 11g.
  

  PLATFORM_ID
  PLATFORM_NAME
  Release name
  PLATFORM_IDs supported within the same Data Guard configuration  when using Data Guard SQL Apply (Logical Standby)
  2
  Solaris[tm] OE (64-bit)
  Solaris Operating System (SPARC) (64-bit)
  2
  3
  HP-UX (64-bit)
  HP-UX PA-RISC
  3, 4
  4
  HP-UX IA (64-bit)
  HP-UX Itanium
  3, 4
  5
  HP Tru64 UNIX
  HP Tru64 UNIX
  5
  6
  AIX-Based Systems (64-bit)
  AIX5L
  6
  7
  Microsoft Windows (32-bit)
  Microsoft Windows (x86)
  7
  10 requires patch for Bug 13104881
  8, 12 - Replication can only occur from a 32-bit primary to a 64-bit standby,  once a role transition has promoted the 64-bit system to the primary role,  the original 32-bit primary is not supported as a standby database.
  8
  Microsoft Windows IA (64-bit)
  Microsoft Windows (64-bit Itanium)
  7 - Replication can only occur from a 32-bit primary to a 64-bit  standby, once a role transition has promoted the 64-bit system to the primary  role, the original 32-bit primary is not supported as a standby database.
  8, 12
  11, 13, both require patch for Bug 13104881
  9
  IBM zSeries Based Linux
  z/Linux
  9
  10
  Linux (32-bit)
  Linux x86
  7, requires patch for Bug 13104881
  10
  11, 13 - Replication can only occur from a 32-bit primary to a 64-bit  standby, once a role transition has promoted the 64-bit system to the primary  role, the original 32-bit primary is not supported as a standby database.
  11
  Linux IA (64-bit)
  Linux Itanium
  10 - Replication can only occur from a 32-bit primary to a  64-bit standby, once a role transition has promoted the 64-bit system to the  primary role, the original 32-bit primary is not supported as a standby  database.
  8, requires patch for Bug 13104881
  11, 13
  12
  Microsoft Windows 64-bit for AMD
  Microsoft Windows (x86-64)
  7 - from Oracle 11g onward. Replication can only occur  from a 32-bit primary to a 64-bit standby, once a role transition has  promoted the 64-bit system to the primary role, the original 32-bit primary  is not supported as a standby database.
  8, 12
  13
  Linux 64-bit for AMD
  Linux x86-64
  10 -Replication can only occur from a 32-bit primary to a 64-bit  standby, once a role transition has promoted the 64-bit system to the primary  role, the original 32-bit primary is not supported as a standby database.
  8, requires patch for Bug 13104881
  11, 13
  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
  18
  IBM Power Based Linux
  Linux on Power
  18
  20
  Solaris Operating System (AMD64)
  Solaris Operating System (x86-64)
  20
  
  
Additional information:
  Mixing Database Versions During Database Rolling Upgrades:Beginning with Oracle Database 10.1.0.3 and onward, a logical standby databasecan operate at a later Oracle release than on the primary when using SQL Applyto execute a rolling database upgrade. Please refer to "Rolling Database Upgrades using Data GuardSQL Apply", "Rolling Database Upgrades for PhysicalStandby Databases using Transient Logical Standby 11g",
DataGuard Configurations that Include a Combination of Physical and Logical StandbyDatabases:A Data Guardconfiguration includes a primary database and up to 30 standby databases.These standby databases may be a mix of physical and logical standby databases.All logical standby databases within a single Data Guard configuration mustadhere to the requirements described in this note. Likewise, if theconfiguration includes physical standby databases, they must conform to therequirements of Support Note 413484.1.

Real Application Cluster &Automatic Storage Management:It isnot necessary that the primary and the standby both be Oracle RAC databases, orboth use ASM. For example, the primary database may be running Oracle RAC withor without ASM, and the standby database(s) may be single-instance, with orwithout ASM. Also, in case both the primary and standby are Oracle RACdatabases, the number of Oracle RAC nodes between the primary and standbydatabases may vary. Furthermore, the versions of ASM and CRS do not need to bethe same between the primary and standby systems.

Exadata Database Machine:It is transparent to Data Guardwhether primary and/or standby databases reside on Exadata Database Machine oron other hardware, as long as the platform ID's of primary and standby systemswithin the same Data Guard configuration conform to the support requirementsdefined in the above table. If Exadata Hybrid Columnar Compression isused, it is strongly recommended that both primary and standby databases resideon Exadata storage. Note that Data Guard SQL Apply adds support for EHCC inOracle Database 11.2.0.2. See the Maximum Availability Architecture BestPractice paper, "Disaster Recovery for Exadata Database Machine".
  
  
  
  
  
  
  -------------------------------------------------------------------------------------------------------
  版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
  Email:  tianlesoftware@gmail.com
  Skype:  tianlesoftware
  Blog: http://www.tianlesoftware.com
  Weibo:  http://weibo.com/tianlesoftware
  Twitter: http://twitter.com/tianlesoftware
  Facebook: http://www.facebook.com/tianlesoftware
  
  -------加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请----
  DBA1 群:62697716(满); DBA2 群:62697977(满)DBA3 群:62697850(满)
  DBA 超级群:63306533(满); DBA4 群:83829929 DBA5群: 142216823
  DBA6 群:158654907 DBA7 群:172855474 DBA总群:104207940

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-251477-1-1.html 上篇帖子: oracle死锁原因及解决方法 下篇帖子: ORACLE用户常用数据字典的查询
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表