由于环境限制，现在需要把2套rac集群通过dg复制指向远端的单机多实例上面。

rac指向第一个实例的前面已经有文档

这里直接添加第二个实例的复制搭建，主要标出不同地方

SQL*Plus: Release 11.2.0.4.0 Production

基本步骤与上面相同，只是实例名有不同之处

1 主库rac集群，设置为归档，和force logging模式

2 主库添加 standby Redo log 文件

3 主备库修改listener.ora 和tnsnames.ora 文件

主库与之前基本相同

备库

[oracle@dg1 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
 (SID_LIST =
 (SID_DESC =
 (GLOBAL_DBNAME = orcl)
 (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
 (SID_NAME = orcl)
 )
 (SID_DESC =
 (GLOBAL_DBNAME = cad)
 (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
 (SID_NAME = cad)  ---在主机dg1上 ，添加2个实例
)
 )

LISTENER =
 (DESCRIPTION_LIST =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
 )
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
 )
 )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@dg1 admin]$ cat tnsnames.ora
bol=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.15)(PORT = 1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.16)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME =bol)
 )
 )

orcl=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.30)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME =orcl)
 )
 )

cad=
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.30)(PORT = 1521))
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME =cad)
 )
 )
[oracle@rac07 ~]$ tnsping cad

4 在备库创建相应的目录
mkdir -p /u01/app/oracle/fast_recovery_area/cad
mkdir -p /u01/app/oracle/oradata/cad/data
mkdir -p /u01/app/oracle/oradata/cad/tempfile
mkdir -p /u01/app/oracle/admin/cad/adump
mkdir -p /u01/app/oracle/admin/cad/data
mkdir -p /u01/app/oracle/admin/cad/redo
mkdir -p /u01/app/oracle/admin/cad/tempfile
mkdir -p /u01/app/oracle/archive/cad