同步表添加附加日志
GGSCI>add trandata test.tab2
|
抽取进程和投递进程参数添加同步表
GGSCI>edit params EXTEST01
Table test.tab2;
GGSCI>edit params PUTEST01
Table test.tab2;
|
目标端停止进程
源端查看当前SCN
SQL> col scn for 9999999999999999
SQL> select dbms_flashback.get_system_change_number scn from dual;
|
源端根据SCN导出同步表
$ expdp '\sys/luhengxing as sysdba'\ DIRECTORY=DMP_DIR DUMPFILE=OGG.DMP LOGFILE=OGG.LOG CLUSTER=N FLASHBACK_SCN=100000 TABLES=TEST.TAB1
|
目标端导入同步表数据
$ impdp '\sys/luhengxing as sysdba'\ DIRECTORY=DMP_DIR DUMPFILE=OGG.DMP LOGFILE=OGG.LOG CLUSTER=N TABLE_EXISTS_ACTION=replace remap_tablespace=TEST:TEST remap_schema=TEST:TEST
|
复制进程参数添加同步表
GGSCI>edit params RETEST01
Map test.tab2,target test.tab2, filter ( @getenv('TRANSACTION', 'CSN') > 9490772077906) ;
|
Tips：filter参数需要在进程下一次重启前取消
启动复制进程
)