由于本实验采用scott模式，在每个oracle
数据库均已默认安装，因此不再需要准备。第2步可使用datapump，goldengatedirect load， sql*loader等方法。
4、配置源端提取
（1）增加抽取组
[sql]
GGSCI (irms156) 1> add extracteoragd, tranlog, begin now, threads 1
EXTRACT added.
GGSCI (irms156) 2> info extracteoragd
EXTRACT EORAGD Initialized 2013-05-1414:58 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:13 ago)
Log Read Checkpoint
Oracle Redo Logs
2013-05-14 14:58:05 Thread 1, Seqno 0, RBA 0
SCN 0.0 (0)
Log Read Checkpoint Oracle Redo Logs
2013-05-14 14:58:05 Thread 2, Seqno 0, RBA 0
SCN 0.0 (0)
（2）创建抽取进程参数文件
[sql]
GGSCI (irms156) 3> edit params eoragd
EXTRACT EORAGD
USERID system, PASSWORD Lu123456
RMTHOST 10.252.48.155, MGRPORT 7809
RMTTRAIL ./dirdat/gd
TABLE scott.emp;
TABLE scott.dept;
TABLE scott.salgrade;
TABLE scott.bonus;
（3）Define the GoldenGate trail
add thetrail that will store the changes on the target.
GGSCI (irms156) 8> add RMTTRAIL./dirdat/gd, EXTRACT EORAGD
RMTTRAIL added.
GGSCI(irms156) 9> info rmttrail *
Extract Trail: ./dir/gd
Extract: EORAGD
Seqno: 0
RBA: 0
File Size: 5M
(4)启动抽取进程并验证
GGSCI (irms156) 10> start extracteoragd
Sending START request to MANAGER ...
EXTRACT EORAGD starting
GGSCI (irms156) 11> info extracteoragd, detail
GGSCI(irms156) 12> view report eoragd
5、配置目标端检查点表
（1）配置全局参数文件并增加检查点表(checkpoint table)
[sql]
GGSCI (irms155) 1> edit params./globals
checkpointtablescott.ggschkpt
（2）激活GLOBALS参数文件
直接退出再进入ggsci即可生效。
[sql]
GGSCI (irms155) 2> exit
（3）增加检查点表
[sql]
GGSCI (irms155) 1> dblogin useridsystem, password Lu123456
Successfully logged into database.
GGSCI (irms155) 3> addcheckpointtable scott.ggschkpt
Successfully created checkpoint tablescott.ggschkpt.
6、配置目标端变更投递
（1）增加replicat组
[sql]
GGSCI (irms155) 5> add replicatroranf, exttrail ./dirdat/gd, checkpointtable scott.ggschkpt
REPLICAT added.
与源端的配置保持一致。
（2）创建replicat参数文件
[sql]
GGSCI (irms155) 7> edit params roranf
REPLICAT RORANF
USERID system, PASSWORD Lu123456
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORANF.DSC, PURGE
MAP scott.emp, TARGET scott.emp;
MAP scott.salgrade, TARGET scott.salgrade;
MAP scott.bonus, TARGET scott.bonus;
MAP scott.dept, TARGET scott.dept;
（3）启动replicat进程
[sql]
GGSCI (irms155) 8> start replicatroranf
Sending START request to MANAGER ...
REPLICAT RORANF starting
GGSCI (irms155) 9> info replicatroranf
REPLICAT RORANF Last Started 2013-05-14 15:39 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:09 ago)
Log Read Checkpoint File ./dirdat/nf000000
First Record RBA 0
GGSCI (irms155) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING RORANF 00:00:00 00:00:02