使用@range拆分复制进程

 

函数@RANGE (1, n,字段1,字段2...)拆分,你打算对这个表拆分分成几个进程,n就是几,相应的创建n个复制进程

同时这里的字段必须是主键或是keycols定义的列

1.给准备新建的进程添加参数文件
添加replicate 进程

 

add replicat repep1,exttrail /goldengate19c/dirdat/pump103/ep  nodbcheckpoint
add replicat repep2,exttrail /goldengate19c/dirdat/pump103/ep  nodbcheckpoint

GGSCI (dba) 5> view params repep1
replicat repep1
useridalias slave
DiscardFile ./dirrpt/repep.dsc, append, Megabytes 200
gettruncates
AllowNoopUpdates
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DBOPTIONS DEFERREFCONST
HANDLECOLLISIONS
MAP hxl.tb_ogg_test,TARGET hxl.tb_ogg_test,filter(
@range(1,2,id)
);
DDLERROR 10655 IGNORE
DDLERROR 10636 IGNORE


GGSCI (dba) 5> view params repep2
replicat repep2
useridalias slave
DiscardFile ./dirrpt/repep.dsc, append, Megabytes 200
gettruncates
AllowNoopUpdates
ASSUMETARGETDEFS
DBOPTIONS SUPPRESSTRIGGERS
DBOPTIONS DEFERREFCONST
HANDLECOLLISIONS
MAP hxl.tb_ogg_test,TARGET hxl.tb_ogg_test,filter(
@range(2,2,id)
);
DDLERROR 10655 IGNORE
DDLERROR 10636 IGNORE

 

2.停掉之前的复制进程
GGSCI (ogg) 135> stop repep

 

3.查看之前复制进程的Sequence 和RBA

GGSCI (ogg as goldengate@slavea) 9> info repep,showch

REPLICAT   REPEP     Last Started 2023-03-13 04:58   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint  File /goldengate19c/dirdat/pump103/ep000000039
                     2023-03-13 04:58:53.000632  RBA 23978


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 39
    RBA: 19706
    Timestamp: 2023-03-13 04:46:13.000445
    Extract Trail: /goldengate19c/dirdat/pump103/ep
    Seqno Length: 9

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 39
    RBA: 23978
    Timestamp: 2023-03-13 04:58:53.000632
    Extract Trail: /goldengate19c/dirdat/pump103/ep
    Seqno Length: 9

Header:
  Version = 2
  Record Source = A
  Type = 1
  # Input Checkpoints = 1
  # Output Checkpoints = 0

Configuration:
  Data Source = 0
  Transaction Integrity = -1
  Task Type = 0

Database Checkpoint:
  Checkpoint table = goldengate.checkpoint
  Key = 1209305712 (0x48148a70)
  Create Time = 2023-02-15 00:58:58

Status:
  Start Time = 2023-03-13 04:58:05
  Last Update Time = 2023-03-13 05:00:08
  Stop Status = G
  Last Result = 400

 

4.修改
alter repep1 extseqno 39, extrba 23978
alter repep2 extseqno 39, extrba 23978

 

5.启动
start repep1
start repep2