goldengate ogg Datapump和replicat拆分方法

ALLSTARS_ORACLE

goldengate ogg         Datapump和replicat拆分方法

下面以拆分replicat为例，datapump拆分方法相同。
1、        停止replicat进程
2、        查看检查点
GGSCI> INFO replicat_name, SHOWCH
REPLICAT   RPEF      Last Started 2011-01-28 12:30   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  File ./dirdat/ef000006
                     2011-01-28 12:47:45.000000  RBA 149258


Current Checkpoint Detail:

Read Checkpoint #1

  GGS Log Trail

  Startup Checkpoint (starting position in the data source):
    Sequence #: 4
    RBA: 1845
    Timestamp: 2011-01-28 11:32:10.556000
    Extract Trail: ./dirdat/ef

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 6
    RBA: 149258
    Timestamp: 2011-01-28 12:47:45.000000
    Extract Trail: ./dirdat/ef

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 = GGS.GGSCHKPT
  Key = 746337239 (0x2c7c33d7)
  Create Time = 2011-01-28 10:20:18

Status:
  Start Time = 2011-01-28 12:30:23
  Last Update Time = 2011-01-28 13:25:34
  Stop Status = A
  Last Result = 400
3、        修改原有参数文件，将拆分出的表删除
4、        新增replicat，和拆分前的进程读取相同的队列文件
5、        修改检查点
GGSCI>alter replicat_new extseqno 6, extrba 149258
6、        确认所有参数文件无误，启动进程即可