GoldenGate单向表DML同步(五)
13:51:08 (activity since 2013-04-16 13:51:02)
From Table OGGUSER.TCUSTMER to OGGUSER.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table OGGUSER.TCUSTORD to OGGUSER.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
...
检查目标库数据记录是否已经同步：
[oracle@kf2 ogg11]$ sqlplus ogguser/ogguser
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 16 13:55:30 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from tcustmer;
CUST NAME CITY ST
---- ------------------------------ -------------------- --
WILL BG SOFTWARE CO. SEATTLE WA
JANE ROCKY FLYER INC. DENVER CO
SQL> select * from tcustord;
CUST ORDER_DAT PRODUCT_ ORDER_ID PRODUCT_PRICE PRODUCT_AMOUNT TRANSACTION_ID
---- --------- -------- ---------- ------------- -------------- --------------
WILL 30-SEP-94 CAR 144 17520 3 100
JANE 11-NOV-95 PLANE 256 133300 1 100
8. 配置DML方式
源库添加extract组和参数文件：
[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) 1> add extract eorakk,tranlog,begin now,threads 1
EXTRACT added.
GGSCI (dd1) 2> info extract *
EXTRACT EORAKK Initialized 2013-04-16 13:54 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:11 ago)
Log Read Checkpoint Oracle Redo Logs
2013-04-16 13:54:23 Thread 1, Seqno 0, RBA 0
GGSCI (dd1) 3> edit params eorakk
EXTRACT EORAKK
USERID system, PASSWORD "calvin"
RMTHOST 192.168.130.171, MGRPORT 7809 ##目标库host
RMTTRAIL ./dirdat/kk
TABLE ogguser.TCUSTMER;
TABLE ogguser.TCUSTORD;
在源库添加remottrail并启动extract：
GGSCI (dd1) 4> ADD RMTTRAIL ./dirdat/kk, EXTRACT EORAKK, MEGABYTES 5
RMTTRAIL added.
GGSCI (dd1) 5> INFO RMTTRAIL *
Extract Trail: ./dirdat/kk
Extract: EORAKK
Seqno: 0
RBA: 0
File Size: 5M
GGSCI (dd1) 6> start extract eorakk
Sending START request to MANAGER ...
EXTRACT EORAKK starting
GGSCI (dd1) 7>
在目标库配置全局参数文件：
[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> edit params ./GLOBALS
CHECKPOINTTABLE system.ggchkptable
添