需求：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博客

OGG 复制进程拆分

最新文章