日期:2014-05-16 浏览次数:20522 次
环境介绍:
这个例子是如何配置单实例到单实例的单向复制.
环境如下表:
|
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)
)
)