checkpoint



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

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

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

Status:
  Start Time = 2014-11-03 15:41:29
  Last Update Time = 2014-11-03 15:41:50
  Stop Status = A
  Last Result = 0


修改抽取进程启动位置,两个进程
GGSCI (node3) 7> ALTER EXTRACT ex1, EXTSEQNO 21, EXTRBA 27644432 THREAD 1
EXTRACT altered.

GGSCI (node3) 8> ALTER EXTRACT ex1, EXTSEQNO 29, EXTRBA 7750160 THREAD 2
EXTRACT altered.


重启进程后源端发起提交命名,结束该事务。
SYS@PROD2 > commit;

Commit complete.

第1000001条数据插入完成
SYS@PROD2 > select count(*) from snow.t1;

  COUNT(*)
----------
   1000001

目标端第1000001条数据复制完成! 
SQL> select count(*) from snow.t1;

  COUNT(*)
----------
   1000001

实验结束
请使用浏览器的分享功能分享到微信等