简单说明:
OGG提供了应用进程延迟同步的功能,本篇博文主要测试该特性
依据《11. Setting up a simple GoldenGate replication confguration between two single node databases》
部署试验环境模拟本次实验,将该博文实验步骤全部执行完毕
实验步骤:
1° 目标库EMP表新增两个字段用于验证:
su - oracle
sqlplus scott/tiger
ALTER TABLE EMP ADD(SOURCE_COMMIT_TIME TIMESTAMP);
ALTER TABLE EMP ADD(TARGET_COMMIT_TIME TIMESTAMP);
exit
2° 源端改写抽取和发送进程并重启:
su - oracle
cd /ggs/dirprm
cat >EGGTEST1.prm<<EOF
EXTRACT EGGTEST1
USERID ggs, PASSWORD ggs
EXTTRAIL /ggs/dirdat/st
TABLE SCOTT.EMP, TOKENS (ORIG_TS = @GETENV("GGHEADER", "COMMITTIMESTAMP"));
-- 使用TOKENS抽取提交的时间只是为了验证延迟应用
EOF
cat >PGGTEST1.prm<<EOF
EXTRACT PGGTEST1
USERID ggs, PASSWORD ggs
RMTHOST 192.168.77.11, MGRPORT 8809
RMTTRAIL /ggs/dirdat/rt
TABLE SCOTT.EMP;
EOF
cd /ggs
./ggsci
stop *
start *
exit
3° 目标端改写应用进程并重启:
su - oracle
cd /ggs/dirprm
cat >RGGTEST1.prm<<EOF
REPLICAT RGGTEST1
USERID ggs, PASSWORD ggs
DISCARDFILE /ggs/dirrpt/RGGTEST1.dsc, append, MEGABYTES 500
ASSUMETARGETDEFS
DEFERAPPLYINTERVAL 5MINS
-- 该参数就是延迟同步参数
-- 延迟的单位可以是:SECS、MINS、MINUTES、HOURS和DAYS
MAP SCOTT.EMP, TARGET SCOTT.EMP, &
COLMAP(USEDEFAULTS, SOURCE_COMMIT_TIME = @TOKEN ("ORIG_TS"), &
TARGET_COMMIT_TIME=@DATE ("YYYYMM-DD HH:MI:SS.FFFFFF","JTS",@GETENV ("JULIANTIMESTAMP")));
EOF
cd /ggs
./ggsci
stop *
start *
exit
4° 测试验证:
# 源端操作
su - oracle
sqlplus scott/tiger
insert into emp values(9999,'vincent','vincent',7788,sysdate,100,100,10);
COMMIT;
exit
# 目标端验证
su - oracle
sqlplus scott/tiger
col SOURCE_COMMIT_TIME for a50
col TARGET_COMMIT_TIME for a50
set linesize 200
select EMPNO,ENAME,SOURCE_COMMIT_TIME,TARGET_COMMIT_TIME from emp;
exit
# 数据延迟同步,对应的列时间戳相差5分钟,实验成功
[TOC]