30. Creating a GoldenGate confguration to run a Shell script when an end-of-day processing record is

简单说明：

OGG提供了EVENTMARKER特性，可以用来创建事件并执行它，本篇博文主要测试该特性
依据《11. Setting up a simple GoldenGate replication confguration between two single node databases》
部署试验环境模拟本次实验，将该博文实验步骤全部执行完毕

环境准备：

1° 源端和目标端均创建标志状态的表，该表触发事件的执行

su - oracle
sqlplus scott/tiger
create table PROCESS_STATUS
(
  EVENTNO  NUMBER not null, 
  EVENTTIME DATE,
  STATE    VARCHAR2(255)
);
alter table PROCESS_STATUS
  add constraint PK_PROCESS_STATUS primary key (EVENTNO)
  using index;
exit
cd /ggs
./ggsci
DBLOGIN, USERID ggs PASSWORD ggs
ADD TRANDATA scott.*
INFO TRANDATA scott.*
exit

2° 目标端创建时间执行的简单脚本：

su - oracle
cat >/ggs/testEvent.sh<<EOF
#!/bin/bash
source ~/.bash_profile
echo "\$(date +%F_%T) testEvent">>/tmp/testEvent.log
# 该脚本需要在成功执行后返回成功状态0
exit 0
EOF
chmod +x /ggs/testEvent.sh

实验步骤：

1° 源端抽取和发送进程保持配置不变，正常启动状态

2° 目标端改写应用进程并重启：

su - oracle
cd /ggs/dirprm
cat>RGGTEST1.prm<<EOF
REPLICAT RGGTEST1
USERID ggs, PASSWORD ggs
DISCARDFILE /ggs/dirrpt/RGGTEST1.dsc, append, MEGABYTES 500
ASSUMETARGETDEFS
MAP SCOTT.BONUS, TARGET SCOTT.BONUS;
MAP SCOTT.SALGRADE, TARGET SCOTT.SALGRADE;
MAP SCOTT.DEPT, TARGET SCOTT.DEPT;
MAP SCOTT.EMP, TARGET SCOTT.EMP;
MAP SCOTT.PROCESS_STATUS, TARGET SCOTT.PROCESS_STATUS, &
    FILTER (@STREQ(STATE, "EOF COMPLETE")=1), EVENTACTIONS (SHELL "/ggs/testEvent.sh");
EOF
cd /ggs
echo 'STOP   REPLICAT RGGTEST1'|./ggsci
echo 'START  REPLICAT RGGTEST1'|./ggsci
echo 'STATUS REPLICAT RGGTEST1'|./ggsci

3° 测试验证：

# 源端操作
su - oracle
sqlplus scott/tiger
INSERT INTO PROCESS_STATUS VALUES (1, SYSDATE, 'EOF COMPLETE');
commit;
exit

# 目标端验证
sqlplus scott/tiger
select * from PROCESS_STATUS;
exit
cat /tmp/testEvent.log
# 表数据复制，触发EVENT，测试成功

[TOC]