日期:2014-05-16  浏览次数:20493 次

流复制实验之:Streams_single_to_RAC_schames

环境介绍:

这个例子是如何配置单实例到RAC的单向复制.

由于条件限制,单实例数据库同样建在了inode2机器上。

如下表:

 

Source (single instance)

Target (RAC)

IP

172.28.7.244

172.28.7.70

172.28.7.244

OS

Oracle 10.2.0.1 for AIX5.3

Oracle 10.2.0.1 for AIX5.3

DB_NAME

orcl

orcl

Host name

Inode2

Inode1/inode2

global_name

infradb.test.lcz.com.cn

orcl.test.lcz.com.cn

service_names

infradb.test.lcz.com.cn

orcl.test.lcz.com.cn

 

 

配置步骤:

(1).配置tnsnames.ora

初始single\rac(orcl1,orcl2)两个数据库的tnsnames.ora内容相同。

 

orcl2.test.lcz.com.cn =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = inode2-vip)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl.test.lcz.com.cn)

      (INSTANC