使用expdp和impdp进行goldengate初始化

环境:

OS:Centos 6

DB:11.2.0.4

 

1.源库导出同步的表
获取当前系统时间
SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;

 

expdp goldengate/goldengate tables=hxl.tb_test01,hxl.tb_test02 dumpfile=tb_test.20211206_11g_%u.dmp FLASHBACK_TIME=\"to_timestamp\(\'2021-12-06 11:46:00\',\'yyyy-mm-dd hh24:mi:ss\'\)\" parallel=5 directory=data_pump_dir cluster=n reuse_dumpfiles=true version=11.2.0.4

 

找到导出的路径

 

SQL> set linesize 1000;
SQL> column owner format a10;
SQL> column directory_name format a32;
SQL> column directory_path format a64;
SQL> select owner,directory_name,directory_path from dba_directories where directory_name='DATA_PUMP_DIR';

OWNER      DIRECTORY_NAME                   DIRECTORY_PATH
---------- -------------------------------- ----------------------------------------------------------------
SYS        DATA_PUMP_DIR                    /u01/oracle/app/product/12.2.0.1/db_1/rdbms/log/

 

 

 

 

2.将导出文件拷贝到目的库的data_pump_dir目录
scp tb_test.20211206_11g_01.dmp oracle@192.168.56.66:/home/oracle/dumpdir/
scp tb_test.20211206_11g_02.dmp oracle@192.168.56.66:/home/oracle/dumpdir/

 

3.导入

impdp goldengate/goldengate directory=data_pump_dir dumpfile=tb_test.20211206_11g_%u.dmp cluster=n tables=hxl.tb_test01,hxl.tb_test02 table_exists_action=replace

 

 4.获取scn(源库查询,注意必须是源库)

SQL> select timestamp_to_scn(TO_TIMESTAMP('2021-12-06 11:46:00', 'YYYY-MM-DD HH24:MI:SS')) ts from dual;

TS
----------
1025403

 

5.启动复制进程
start repep aftercsn 1025403