日期:2014-05-16 浏览次数:20645 次
环境介绍:
这个例子是如何配置单实例到单实例的单向复制.
环境如下表:
| 
 
  | 
 Source (single instance)  | 
 Target (single instance)  | 
| 
 IP  | 
 172.28.7.244  | 
 172.28.7.11  | 
| 
 OS  | 
 Oracle 10.2.0.1 for AIX5.3  | 
 Oracle 10.2.0.1 for windows XP  | 
| 
 DB_NAME  | 
 orcl  | 
 orcl  | 
| 
 Host name  | 
 Inode2  | 
 Ch-f  | 
| 
 global_name  | 
 orcl.test.lcz.com.cn  | 
 testdb.test.lcz.com.cn  | 
| 
 service_names  | 
 orcl.test.lcz.com.cn  | 
 testdb.test.lcz.com.cn  | 
配置步骤:
(1).配置tnsnames.ora
初始single\rac(orcl1,orcl2)两个数据库的tnsnames.ora内容相同。
orcl.test.lcz.com.cn =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.28.7.244)(PORT = 1522))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(sid = orcl)
)
)