/ 该参数加到主端和备端的extract 参数文件中，否则会出现死循环复制。 /span
在写这篇文章之前，xxx经已写过了几篇关于改参数、配置-主题的文章,想要了解的朋友可以去翻一下之前的文章
续继上一篇的试验。
节点说明：
dd1(源库)--->>kf2(目标库)
dd1(目标库)<<---kf2(源库)
在配置向反制复中程过，可临时把源库和目标库更换位置，配置基本上同雷。
但在官网上有说明要注意的一个地方：
Do either of the following to specify the Replicat database us er. All transactions generated
by this user will be excluded from being captured. This information is available to Extract
in the transaction record.
● Identify the Replicat database user by name with the following parameter statement
in the Extract parameter file.
TRANLOGOPTIONS EXCLUDEUSER <user name>
该参数加到主端和备端的extract 参数文件中，否则会涌现死循环制复。
1. 在dd1上配置全局参数
GGSCI (dd1) 1> view params ./GLOBALS
ggschema ogguser
GGSCI (dd1) 2> edit params ./GLOBALS
ggschema ogguser
checkpointtable ogguser.checkpoint
GGSCI (dd1) 3> dblogin userid ogguser@test1,password ogguser
Successfully logged into database.
添加checkpoint表：
GGSCI (dd1) 4> add checkpointtable
ERROR: Missing checkpoint table specification.
GGSCI (dd1) 5> add checkpointtable ogguser.checkpoint
Successfully created checkpoint table OGGUSER.CHECKPOINT.
2. 在kf2上确认全局参数，开启附加日记，制强日记，档归
GGSCI (kf2.calvin) 4> view params ./GLOBALS
GGSCHEMA ogguser
CHECKPOINTTABLE ogguser.checkpoint
SQL> alter database add supplemental log data;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter database force logging;
Database altered.
SQL> alter system set recyclebin=off scope=spfile;
System altered.
SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;
LOG_MODE SUPPLEME FOR
------------ -------- ---
ARCHIVELOG YES YES
3. 在kf2上配置ddl支撑
SQL> @marker_setup.sql
SQL> @ddl_setup.sql
SQL> @role_setup.sql
SQL> grant GGS_GGSUSER_ROLE to ogguser;
SQL> @ddl_enable.sql
SQL> @?/rdbms/admin/dbmspool.sql
SQL> @ddl_pin.sql ogguser
4. 在kf2上添加extract，exttrail，并配置参数
GGSCI (kf2.calvin) 5> dblogin userid ogguser@test2,password ogguser
Successfully logged into database.
GGSCI (kf2.calvin) 6> add extract ext1,tranlog,begin now
EXTRACT added.
GGSCI (kf2.calvin) 7> add exttrail /data/oracle/ogg11/dirdat/lt,extract ext1
EXTTRAIL added.
GGSCI (kf2.calvin) 8> edit params ext1
extract ext1
userid ogguser@test2, password ogguser
tranlogoptions excludeuser ogguser ##免避死循环制复，样同的，dd1上的extract test1参数也要设置
rmthost 192.168.130.168, mgrport 7809
rmttrail /data/oracle/ogg11/dirdat/lt
ddl include mapped objname stat.*;
table stat.*;
GGSCI (kf2.calvin) 4> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:10:24
REPLICAT RUNNING TEST2 00:00:00 00:00:07
5. 在dd1上 添加replicat，extrtrail，并配置参数
GGSCI (dd1) 4> add replicat ext2,exttrail /data/oracle/ogg11/dirdat/lt,checkpointtable ogguser.checkpoint
REPLICAT added.
GGSCI (dd1) 5> edit params ext2
replicat ext2
ASSUMETARGETDEFS
userid ogguser@test1,password ogguser
discardfile /data/oracle/ogg11/dirdat/test1_discard.txt,append, megabytes 10
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
map stat.*, target stat.*;
GGSCI (dd1) 6> start replicat ext2
Sending START request to MANAGER ...
REPLICAT EXT2 starting
GGSCI (dd1) 7> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING TEST1 00:00:00 00:00:06
REPLICAT RUNNING EXT2 00:00:00 00:00:01
6. 测试据数双向同步
kf2:
SQL> create table tp_test2(name varchar2(10));
Table created.
SQL> insert into tp_test2 values('calvin'); ##在kf2上入插据数
1 row created.
SQL> commit;
Commit complete.
SQL> select * from tp_test2;
NAME
----------
calvin
1 row selected
dd1:
SQL> select * from tp_test2;
NAME
----------
calvin ##据数经已同步
SQL> insert into tp_test2 values('fish'); ##在dd1上入插据数
1 row created.
SQL> commit;
Commit complete.
SQL> select * from tp_test2;
NAME
----------
calvin
fish
kf2:
SQL> select * from tp_test2;
NAME
----------
calvin
fish ##据数经已同步
文章结束给大家分享下程序员的一些笑话语录： 自从有了Photoshop，我再也不相信照片了！（没有Photoshop的年代，胶片照片年代做假的也不少，那时候都相信假的！）
