OGG 复制进程拆分

需求：OGG 原来将很多表放到一个复制进程的参数文件里面了需要进行细分把一部分表  划分出来用另外一个进程管理。
原来的复制进程参数文件如下：

黑色框出部门为我们需要拆分出来的表：
步骤：
1、停止replicat 进程
stop replicat_name
2、查看检查点记录下Sequence 和RBA 留做后用
GGSCI (og2) 23> info replgg,showch
REPLICAT   REPLGG    Last Started 2014-07-02 20:26   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:03:01 ago)
Log Read Checkpoint  File /u01/ogg/dirdat/kt000037
                     2014-07-02 20:30:22.699200  RBA 1883
Current Checkpoint Detail:
Read Checkpoint #1
  GGS Log Trail
  Startup Checkpoint (starting position in the data source):
    Sequence #: 35
    RBA: 8430
    Timestamp: 2014-07-02 20:25:05.842502
    Extract Trail: /u01/ogg/dirdat/kt
  Current Checkpoint (position of last record read in the data source):
    Sequence #: 37 
    RBA: 1883   -------RBA和Sequence
    Timestamp: 2014-07-02 20:30:22.699200
    Extract Trail: /u01/ogg/dirdat/kt
CSN state information:
  CRC: 33-3D-71-BC
  Latest CSN: 2736049
  Latest TXN: 1.20.1420
  Latest CSN of finished TXNs: 2736049
  Completed TXNs: 1.20.1420
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 = regg.chkpoint
  Key = 3537550738 (0xd2dabd92)
  Create Time = 2014-05-22 23:49:29
Status:
  Start Time = 2014-07-02 20:26:44
  Last Update Time = 2014-07-04 00:36:42
  Stop Status = G
  Last Result = 400
3、将原来的参数文件中的两张表删除：
4、增加新的复制进程名称为replggg
GGSCI (og2) 26> edit params replggg
参数如下：
replicat replggg
HANDLECOLLISIONS
ASSUMETARGETDEFS
GETTRUNCATES
GROUPTRANSOPS 100
REPORT AT 0:00
ALLOWNOOPUPDATES
ddlerror default ignore retryop maxretries 3 retrydelay 5
USERID regg , PASSWORD regg
DISCARDFILE ./dirrpt/RINIaa.dsc, PURGE
DECRYPTTRAIL AES192 KEYNAME mykey2
map gg.col,target regg.col;
map ggdl.tes,target ggdl.tes;

GGSCI (og2) 27> ADD REPLICAT replggg, EXTTRAIL /u01/ogg/dirdat/kt checkpointtable regg.chkpoint---------这里的trial 文件就是原来的trial 文件检测表用你原来的检测表就行
REPLICAT added.
5、查看添加是否成功
GGSCI (og2) 28> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    STOPPED     REPLGG      00:00:00      00:07:53    
REPLICAT    STOPPED     REPLGGG     00:00:00      00:00:03    
6、修改检查点用到刚才的Sequence 和RBA
GGSCI (og2) 29> alter replggg extseqno 37, extrba 1883
REPLICAT altered.
7、启动进程
start replggg

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