使用Active Database Duplication创建跨平台Data Guard设置 (Windows/Linu

时间:2021-09-21 06:00:40

Using Active Database Duplication to Create Cross Platform Data Guard Setup (Windows/Linux) (Doc ID 881421.1)

APPLIES TO:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

GOAL

Disclaimer:??
NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.  Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.??For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

DB_name=ORA11GR1

DB_UNIQUE_NAMES=CHICAGO,BOSTON

 

This note outlines the required steps to create a physical standby database in Mixed environment using 11g RMAN Active Duplicate.  本说明概述了使用11g RMAN Active Duplicate在混合环境中创建物理备用数据库的必需步骤

You can configure cross platform (database that runs on a different platform  i,e. Linux and Windows) standby database using below Options:  您可以使用以下选项配置跨平台(在不同平台(即Linux和Windows)上运行的数据库)备用数据库

I) Using RMAN Active database duplicate command starting from 11g onwards. Backup-based duplication will only work if we have same file system structure/backup available on sbt device.  使用从11g开始的RMAN Active database duplicate命令。仅当我们在sbt设备上具有相同的文件系统结构/备份可用时,基于备份的复制才有效。
II) Take online backup using RMAN/Traditional method & restore it on standby site.  使用RMAN /传统方法进行在线备份,并将其还原到备用站点上。
II) Restore the offline backup of database.  恢复数据库的脱机备份。

Review below MOS document to check RMAN Mixed platform support:  复查下面的MOS文档以检查RMAN混合平台支持

Note 1079563.1: RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support
<Note  413484.1>: Data Guard Support for Heterogeneous Primary and Standby Systems in Same Data Guard Configuration

SOLUTION

Environment :

Database name for both hosts:  两个主机的数据库名称
db_name=ORA11GR1

Primary database:

Database version : 11.1.0.7.0
OS Make : Linux 32bit
db_unique_name : CHICAGO

Standby Database
Database version : 11.1.0.7.0
OS Make : Windows 32bit
db_unique_name : BOSTON

1. Create parameter file & Oracle Service with the ORADIM Utility for Standby:  ORADIM创建备用参数文件与Oracle服务

a. Copy source database parameter file into %ORACLE_HOME%databaseinitBOSTON.ora  将源数据库参数文件复制到 %ORACLE_HOME%databaseinitBOSTON.ora
Copy source database parameter File & modify the paths & set memory related parameters accordingly:  将源数据库参数文件复制并修改路径并相应地设置与内存相关的参数

Modify the following accordingly for windows host:  为Windows主机相应地修改以下内容:

control_files
diagnostic_dest
db_recovery_file_dest

 

Carefully set following standby parameters for example:  仔细设置以下备用参数,例如

db_file_name_convert=‘/oracle/oradata/CHICAGO/data,‘E:oradataBOSTONdata‘
log_file_name_convert=‘/oracle/oradata/CHICAGO/log‘,‘E:oradataBOSTONlog‘

 

Set following Primary parameters for example:  设置以下Primary参数

db_file_name_convert=‘E:oradataBOSTONdata‘,‘/oracle/oradata/CHICAGO/data‘
log_file_name_convert=‘E:oradataBOSTONlog‘,‘/oracle/oradata/CHICAGO/log‘

 

b. Creating oracle service will also create password file with initial password same as primary:  创建oracle服务还将创建初始密码与primary相同的密码文件

set ORACLE_HOME=<Correct Directory>
set PATH=%PATH%:%ORACLE_HOME%/bin

oradim -new -SID BOSTON -INTPWD primarySysPassword -STARTMODE auto -PFILE "%ORACLE_HOME%databaseinitBOSTON.ora"

 

Startup nomount the auxiliary instance:  启动nomount辅助实例

sqlplus "/ as sysdba"
SQL> startup nomount

 

2) Update tnsnames.ora on primary & standby systems. In this example, Chicago is Primary and Boston is Standby.  在主系统和备用系统上更新tnsnames.ora。在此示例中,Chicago is Primary and Boston is Standby

tnsnames.ora (on both systems): 在两个系统上

BOSTON =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Host Ip Addr>)(PORT = <Port>))
)
(CONNECT_DATA = (SERVICE_NAME = BOSTON))
)

CHICAGO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Host Ip Addr>)(PORT = <Port>))
)
(CONNECT_DATA = (SERVICE_NAME = CHICAGO))
)

 

Make sure tnsping is working & you are able to connect to both databases using sqlplus from both the sites.  确保tnsping正常工作,并且您能够使用sqlplus从两个站点连接到两个数据库

3) Run active database duplication:  

%rman
RMAN> connect target sys/<PASSWORD>@chicago; # Primary
RMAN> connect auxiliary sys/<PASSWORD>@boston; # Standby: tnsname used by primary
RMAN> run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database nofilenamecheck;
}

 

You can then configure this environment for Data Guard.  然后,您可以为Data Guard配置此环境
For compatibility matrix check   有关兼容性矩阵
Note 413484.1: Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration

REFERENCES

NOTE:413484.1 - Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration
NOTE:1079563.1 - RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support