此文将在前两文基础上介绍如何配置一个一对多的数据分布式复制体系。
方法与前面大同小异,再次仅突出重点。
由于测试机器不够,我就在Target上的DB里建立两个User,分别代表两个Target环境。
这里需要注意的是,两个Target可以使用同一个GG binary,也可以使用同一个MGR(同一个port),只是需要配置不同的REPLICAT而已。
1.Source 添加EXTRACT
GGSCI (xxx) 120> ADD EXTRACT HAOEXMUL, TRANLOG, BEGIN now
EXTRACT added.
GGSCI (xxx) 121> edit params HAOEXMUL
EXTRACT HAOEXMUL
SETENV (ORACLE_SID=MOT)
USERID GGS@MOT, PASSWORD GGS
EXTTRAIL ./dirdat/za
TABLE HAOZHU_USER.GGMULTI;
~
"dirprm/haoexmul.prm" 5 lines, 118 characters written
GGSCI (xxx) 124> ADD EXTTRAIL ./dirdat/za, EXTRACT HAOEXMUL
EXTTRAIL added.
GGSCI (xxx) 125> start extract HAOEXMUL
Sending START request to MANAGER ...
EXTRACT HAOEXMUL starting
GGSCI (xxx) 126> info HAOEXMUL
EXTRACT HAOEXMUL Last Started 2010-04-22 12:23 Status RUNNING
Checkpoint Lag 00:13:57 (updated 00:00:03 ago)
Log Read Checkpoint Oracle Redo Logs
2010-04-22 12:09:54 Seqno 64, RBA 8503312
2.Source添加两个data pump EXTRACT
GGSCI (xxx) 110> ADD EXTRACT HAODP1, EXTTRAILSOURCE ./dirdat/za, BEGIN now
EXTRACT added.
GGSCI (xxx) 111> ADD EXTRACT HAODP2, EXTTRAILSOURCE ./dirdat/za, BEGIN now
EXTRACT added.
GGSCI (xxx) 112> ADD RMTTRAIL ./dirdat/za, EXTRACT HAODP1
RMTTRAIL added.
GGSCI (xxx) 113> ADD RMTTRAIL ./dirdat/zb, EXTRACT HAODP2
RMTTRAIL added.
GGSCI (xxx) 114> edit params HAODP1
EXTRACT HAODP1
SETENV (ORACLE_SID=MOT)
USERID GGS@MOT, PASSWORD GGS
RMTHOST xxx.xxx.xxx.xxx, MGRPORT 7809
RMTTRAIL ./dirdat/za
TABLE HAOZHU_USER.GGMULTI;
~
~
"dirprm/haodp1.prm" [New File] 6 lines, 158 characters written
GGSCI (xxx) 115> edit params HAODP2
EXTRACT HAODP2
SETENV (ORACLE_SID=MOT)
USERID GGS@MOT, PASSWORD GGS
RMTHOST xxx.xxx.xxx.xxx, MGRPORT 7809
RMTTRAIL ./dirdat/zb
TABLE HAOZHU_USER.GGMULTI;
~
"dirprm/haodp2.prm" [New File] 6 lines, 159 characters written
GGSCI (xxx) 128> start HAODP1
Sending START request to MANAGER ...
EXTRACT HAODP1 starting
GGSCI (xxx) 129> start HAODP2
Sending START request to MANAGER ...
EXTRACT HAODP2 starting
GGSCI (xxx) 130> info HAODP1
EXTRACT HAODP1 Last Started 2010-04-22 12:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File ./dirdat/za000000
2010-04-22 12:04:39.000000 RBA 0
GGSCI (xxx) 131> info HAODP2
EXTRACT HAODP2 Last Started 2010-04-22 12:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:02 ago)
Log Read Checkpoint File ./dirdat/za000000
2010-04-22 12:04:44.000000 RBA 0
3.Target 添加两个Replicat
GGSCI (xxx) 32> ADD REPLICAT HAOREPA, EXTTRAIL ./dirdat/za, BEGIN now , nodbcheckpoint
REPLICAT added.
GGSCI (xxx) 33> ADD REPLICAT HAOREPB, EXTTRAIL ./dirdat/zb, BEGIN now , nodbcheckpoint
REPLICAT added.
GGSCI (xxx) 34> edit params HAOREPA
REPLICAT HAOREPA
ASSUMETARGETDEFS
SETENV (ORACLE_SID=DC1)
USERID GGS, PASSWORD GGS
map HAOZHU_USER.GGMULTI , target HAOZHU_USER.GGMULTI;
~
"dirprm/haorepa.prm" [New File] 5 lines, 137 characters written
GGSCI (xxx) 35> edit params HAOREPB
REPLICAT HAOREPB
ASSUMETARGETDEFS
SETENV (ORACLE_SID=DC1)
USERID GGS, PASSWORD GGS
map HAOZHU_USER.GGMULTI , target HAOZHU2_USER.GGMULTI;
~
"dirprm/haorepb.prm" [New File] 5 lines, 138 characters written
GGSCI (xxx) 36> start HAOREPA
Sending START request to MANAGER ...
REPLICAT HAOREPA starting
GGSCI (xxx) 37> start HAOREPB
Sending START request to MANAGER ...
REPLICAT HAOREPB starting
GGSCI (xxx) 38> info HAOREPA
REPLICAT HAOREPA Last Started 2010-04-22 12:35 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/za000000
2010-04-22 12:32:46.000000 RBA 0
GGSCI (xxx) 39> info HAOREPB
REPLICAT HAOREPB Last Started 2010-04-22 12:35 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint File ./dirdat/zb000000
2010-04-22 12:32:50.000000 RBA 0
4.测试
在Source:
SQL> insert into ggmulti select * from dba_objects;
10045 rows created.
SQL> commit;
Commit complete.
在Target:
SQL> show user
USER is "HAOZHU2_USER"
SQL> select count(*) from ggmulti;
COUNT(*)
----------
10045
SQL> show user
USER is "HAOZHU_USER"
SQL> select count(*) from ggmulti;
COUNT(*)
----------
10045
(这里感谢Thomas Zhang的帮助让我找到一个配置中的失误:))
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15415488/viewspace-660466/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15415488/viewspace-660466/