goldengate OGG Extract拆分方法

ALLSTARS_ORACLE

goldengate OGG        Extract拆分方法

1、        停止extract进程
2、        停止datapump、进程
GGSCI> INFO datapump_name
EXTRACT    DPEF      Last Started 2011-01-28 12:34   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint  File ./dirdat/ef000010
                     2011-01-28 12:47:45.000000  RBA 148645
直至RBA号不变化，才能停止
3、        停止replicat进程
GGSCI> INFO replicat_name
REPLICAT   RPEF      Last Started 2011-01-28 12:30   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint  File ./dirdat/ef000006
                     2011-01-28 12:47:45.000000  RBA 149258
直至RBA号不变化，才能停止
4、        记录extract检查点
Extract检查点包括：Recovery Checkpoint和Current Checkpoint
GGSCI> INFO extract_name, SHOWCH
EXTRACT    EXEE      Last Started 2011-01-28 09:58   Status STOPPED
Checkpoint Lag       00:00:00 (updated 00:01:02 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2011-01-28 10:02:16  Seqno 26, RBA 7090688
Current Checkpoint Detail:

Read Checkpoint #1

  Oracle Redo Log

  Startup Checkpoint (starting position in the data source):
    Sequence #: 26
    RBA: 289296
    Timestamp: 2011-01-28 09:27:31.000000
    Redo File: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

  Recovery Checkpoint (position of oldest unprocessed transaction in the data source):
    Sequence #: 26
    RBA: 7088144
    Timestamp: 2011-01-28 10:02:16.000000
    Redo File: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

  Current Checkpoint (position of last record read in the data source):
    Sequence #: 26
    RBA: 7090688
    Timestamp: 2011-01-28 10:02:16.000000
    Redo File: C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG

Write Checkpoint #1

  GGS Log Trail

  Current Checkpoint (current write position):
    Sequence #: 11
    RBA: 31609
    Timestamp: 2011-01-28 10:02:19.072000
    Extract Trail: ./dirdat/ee

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

File Information:
  Block Size = 2048
  Max Blocks = 100
  Record Length = 2048
  Current Offset = 0

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

Status:
  Start Time = 2011-01-28 09:58:34
  Last Update Time = 2011-01-28 10:02:19
  Stop Status = G
  Last Result = 400

5、        修改原有相应的参数文件，将拆分出的表从参数文件中删除
6、        增加新的extract，datapump和replicat
--source--------------------------------------------------
GGSCI (win2k364) 15> add ext exef, tranlog, begin now
EXTRACT added.

GGSCI (win2k364) 16> add exttrail ./dirdat/ef, ext exef, megabytes 50
EXTTRAIL added.

GGSCI (win2k364) 17> add ext dpef, exttrailsource ./dirdat/ef
EXTRACT added.

GGSCI (win2k364) 18> add rmttrail ./dirdat/ef, ext dpef, megabytes 50
RMTTRAIL added.

--target--------------------------------------------------
GGSCI (win2k364) 21> add rep rpef, exttrail ./dirdat/ef
REPLICAT added.

7、        修改新增extract进程的检查点
检查点为上面记录的两个检查点：current read checkpoint and recovery checkpoint
--修改current read checkpoint
GGSCI (win2k364) 30> alter exef extseqno 26, extrba 7090688 [, thread n]
EXTRACT altered.
--修改recovery checkpoint
GGSCI (win2k364) 4> alter exef ioextseqno 26, ioextrba 7088144 [, thread n]

2011-01-28 10:46:18  INFO    OGG-00989  WARNING: Unsupported operation. This might cause transactional inconsistency. Modifying iocheckpoint: ioseq = 26 iorba = 7088144.
Are you sure you want to continue? y
EXTRACT altered.

8、        确认所有参数文件正确，启动进程即可