GoldenGate单向表DML同步(四)
no rows selected
7. 一次性抽取源库数据到目标库：
[oracle@dd1 ogg11]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (dd1) 3> dblogin userid system,password calvin
Successfully logged into database.
GGSCI (dd1) 5> add trandata ogguser.tcustmer
Logging of supplemental redo data enabled for table OGGUSER.TCUSTMER.
GGSCI (dd1) 6> add trandata ogguser.tcustord
Logging of supplemental redo data enabled for table OGGUSER.TCUSTORD.
GGSCI (dd1) 7> info trandata ogguser.*
Logging of supplemental redo log data is enabled for table OGGUSER.TCUSTMER
Logging of supplemental redo log data is enabled for table OGGUSER.TCUSTORD
GGSCI (dd1) 8>
源库添加extrace组任务和参数文件：
GGSCI (dd1) 8> add extract einikk,sourceistable
EXTRACT added.
GGSCI (dd1) 9> edit params einikk
-- GoldenGate Inintal Data Capture
-- for TCUSTMER and TCUSTORD
--
EXTRACT EINIKK
USERID system,PASSWORD "calvin"
RMTHOST 192.168.130.171,MGRPORT 7809 ##目标库host
RMTTASK REPLICAT,GROUP RINIKK
TABLE ogguser.TCUSTMER;
TABLE ogguser.TCUSTORD;
~
GGSCI (dd1) 10> info extract *,tasks
EXTRACT EINIKK Initialized 2013-04-16 11:36 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
目标库添加replicat组任务和参数文件：
[oracle@kf2 ogg11]$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
GGSCI (kf2.calvin) 1> add replicat rinikk,specialrun
REPLICAT added.
GGSCI (kf2.calvin) 2> edit params rinikk
--
-- GoldGate Initial Load Delivery
--
replicat rinikk
assumetargetdefs
userid system,password calvin
discardfile ./dirrpt/rinikk.dsc,purge
map ogguser.*, target ogguser.*; --target 和前面的','间必须有一个空格
~
GGSCI (kf2.calvin) 3> info replicat *,task
REPLICAT RINIKK Initialized 2013-04-16 11:45 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:02:52 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
源库启动extract：
GGSCI (dd1) 11> start extract einikk
Sending START request to MANAGER ...
EXTRACT EINIKK starting
看到extract日志有下面内容，说明成功：
GGSCI (dd1) 20> view report einikk
...
Output to RINIKK:
From Table OGGUSER.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table OGGUSER.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
...
目标库查看replicat日志：
GGSCI (kf2.calvin) 2> view report rinikk
...
Report at 2013-04-16