GoldenGate系统二：快速搭建三方单向通信GoldenGate环境(二)
goldengatedirect load， sql*loader等方法。
4、配置源端提取
（1）增加抽取组
广东：
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)
江苏：
GGSCI (irms156) 1> add extract eorajs, tranlog, begin now,threads 1
EXTRACT added.
GGSCI (irms156) 2> info extract eorajs
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）创建抽取进程参数文件
广东：
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;
江苏：
GGSCI (irms156) 3> edit params eorajs
EXTRACT EORAJS
USERID system, PASSWORD Lu123456
RMTHOST 10.252.48.155, MGRPORT 7809
RMTTRAIL ./dirdat/js
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
江苏：
GGSCI (irms156) 8> add RMTTRAIL./dirdat/js, EXTRACTEORAJS
RMTTRAIL added.
GGSCI(irms156) 9> info rmttrail *
Extract Trail: ./dir/js
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
江苏：
GGSCI (irms156) 10> start extracteorajs
Sending START request to MANAGER ...
EXTRACT EORAJS starting
GGSCI (irms156) 11> info extract eorajs, detail
GGSCI (irms156)12> view report eorajs
5、配置目标端检查点表
（1）配置全局参数文件并增加检查点表(checkpoint table)
GGSCI (irms155) 1> edit params./globals
checkpointtablescott.ggschkpt
（2）激活GLOBALS参数文件
直接退出再进入ggsci即可生效。
GGSCI (irms155) 2> exit
（3）增加检查点表
GGSCI (irms155) 1> dblogin useridsystem, password Lu123456
Successfully logged into database.
GGSCI (irms155) 3> addcheckpointtable sco