ITPub博客

首页 > 数据库 > Oracle > OGG 开并发

OGG 开并发

原创 Oracle 作者:aishu521 时间:2014-07-15 17:42:14 0 删除 编辑

数据收集应用比较慢,如果这个进程只有一个大表,我们可以进行开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   reweicob Last 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_2 EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;
GGSCI (wei) 12>ADD REPLICAT reweicob_3 EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;
GGSCI (wei) 12>ADD REPLICAT reweicob_4 EXTTRAIL ./dirdat/ec, CHECKPOINTTABLE GOLDENGATE.CHECKPOINT_WEI ;

5,修改启动sequence

GGSCI (wei) 8> info reweicob

EXTRACT    reweicob Last 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*

以上就完成了


 

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15187685/viewspace-1219731/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: mysql 集群搭建
请登录后发表评论 登录
全部评论

注册时间:2012-05-26

  • 博文量
    139
  • 访问量
    721108