OGG同步初始化数据(上)-dump文件方式

查看数据库当前SCN

SQL> select to_char(current_scn) from v$database; 

CURRENT_SCN
-----------
1085057

导出源表数据(源端抽取进程需打开)

expdp test/test TABLES=test.t1 DUMPFILE=t1.dmp flashback_scn=1085057

dump文件拷贝到目标端,导入数据

impdp test/test dumpfile=t1.dmp

源端开启投递进程后,目标端开启复制进程

GGSCI (test2 as goldengate@test1) 20> start replicat repgs1,aftercsn 1085057

Related Posts