数据收集应用比较慢,如果这个进程只有一个大表,我们可以进行开range,以下开4个并发
步骤如下:
1,编辑参数文件,复制3份
wei:wei> vi reweicob.prm
replicat reweicob
setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
setenv (ORACLE_HOME=/dba/oracle/product/11.2.0.3.0)
setenv (ORACLE_SID=wei)
userid goldengate, password *******
REPORTCOUNT EVERY 30 MINUTES,RATE
REPORT AT 01:59
reportrollover at 02:00
discardrollover on friday
--handlecollisions
reperror default,abend
discardfile ./dirrpt/reweicosbi.dsc,append, megabytes 1000 GOLDENGATE.CHECKPOINT_LGDNEW
复制4份
wei:cos > ls
reweicob_2.prm reweicob_3.prm reweicob_4.prm reweicob.prm
2,对复制的文件进行编辑修改
reweicob_3.prm reweicob_4.prm 一样修改,安红色字体修改
wei:cos > vi reweicob_2.prm
replicat reweicob_2
setenv (NLS_LANG = AMERICAN_AMERICA.AL32UTF8)
setenv (ORACLE_HOME=/dba/oracle/product/11.2.0.3.0)
setenv (ORACLE_SID=cos)
userid goldengate, password *********
REPORTCOUNT EVERY 30 MINUTES,RATE
REPORT AT 01:59
reportrollover at 02:00
discardrollover on friday
--handlecollisions
reperror default,abend
discardfile ./dirrpt/reweicosbi_2.dsc,append, megabytes 1000 GOLDENGATE.CHECKPOINT_LGDNEW
map wei_COS.COMPLAIN, TARGET wei_COS.COMPLAIN, KEYCOLS(JOB_ID),FILTER (@RANGE(2,4,JOB_ID));---job_id 代表主键有几个需要写几个
stop 进程
GGSCI (wei) 8> stop reweicob
文件主要修改内容如下:
map wei_table.wei, TARGET wei_table.wei, KEYCOLS(JOB_ID),FILTER (@RANGE(1,4,JOB_ID));
map wei_table.wei, TARGET wei_table.wei, KEYCOLS(JOB_ID),FILTER (@RANGE(2,4,JOB_ID));
map wei_table.wei, TARGET wei_table.wei, KEYCOLS(JOB_ID),FILTER (@RANGE(3,4,JOB_ID));
map wei_table.wei, TARGET wei_table.wei, KEYCOLS(JOB_ID),FILTER (@RANGE(4,4,JOB_ID));
3,查看配置和检查点 --可以看到checkpoint table
GGSCI (wei) 59> info reweicob,showch
REPLICAT reweicobLast Started 2014-07-01 17:16 Status RUNNING
Checkpoint Lag 134:27:21 (updated 00:00:08 ago)
Log Read Checkpoint File ./dirdat/bl003434
2014-06-26 02:52:02.001428 RBA 107646919
Current Checkpoint Detail:
Read Checkpoint #1
GGS Log Trail
Startup Checkpoint (starting position in the data source):
Sequence #: 3434
RBA: 103090812
Timestamp: 2014-06-26 02:50:34.000873
Extract Trail: ./dirdat/bl
Current Checkpoint (position of last record read in the data source):
Sequence #: 3434
RBA: 107646919
Timestamp: 2014-06-26 02:52:02.001428
Extract Trail: ./dirdat/ec
Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 0
File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0
Configuration:
Data Source = 0
Transaction Integrity = -1
Task Type = 0
Database Checkpoint:
Checkpoint table = GOLDENGATE.CHECKPOINT_WEI Key = 1454367534 (0x56afe32e)
Create Time = 2014-05-24 21:34:13
Status:
Start Time = 2014-07-01 17:16:50
Last Update Time = 2014-07-01 17:19:23
Stop Status = A
Last Result = 0
4,增加进程
GGSCI (wei) 11> dblogin userid goldengate, password test3213_a
GGSCI (wei) 12>ADD REPLICAT reweicob_2EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;
GGSCI (wei) 12>ADD REPLICAT reweicob_3EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;
GGSCI (wei) 12>ADD REPLICAT reweicob_4EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;
5,修改启动sequence
GGSCI (wei) 8> info reweicob
EXTRACT reweicobLast Started 2014-06-28 23:28 Status stop
Checkpoint Lag 00:03:44 (updated 00:00:00 ago)
Log Read Checkpoint Oracle Redo Logs
2014-07-15 17:27:15 Thread 1, Seqno 000301, RBA 46033645
GGSCI (wei) 12> alter reweicob_2 , extseqno 301, extrba 46033645
GGSCI (wei) 12> alter reweicob_3 , extseqno 301, extrba 46033645
GGSCI (wei) 12> alter reweicob_4, extseqno 301, extrba 46033645
6,启动修改的后各进程
GGSCI (wei) 12> start reweicob*
以上就完成了