oracle ogg 多线程,OGG 开并发

数据收集应用比较慢，如果这个进程只有一个大表，我们可以进行开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*

以上就完成了