Oracle GoldenGate Trail file encryption

GoldenGate加密trail文件非常简单,只需要在extract参数中加上encrypttrail参数。extract进程就会对加入此参数后所生产的trail文件进行加密,如果目标端的replicat参数没有加上对应的decrypttrail参数解密trail文件后再入库,replicat进程就会abend

源端extract参数

GGSCI (gg01) 5> VIEW params eorajj

EXTRACT EORAJJ
USERID system, PASSWORD oracle
RMTHOST gg02, MGRPORT 7809
--加密参数
ENCRYPTTRAIL
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj

DDL INCLUDE ALL
DDLOPTIONS ADDTRANDATA,REPORT
TRANLOGOPTIONS CONVERTUCS2CLOBS

TABLE scott.stu;
SEQUENCE scott.*;

源端插入数据测试

SCOTT@gg01:~>INSERT INTO stu 
  2  VALUES 
  3  (5,'TEST','TEST@126.com','138xxxxxxxx','TRAIL');

1 ROW created.

SCOTT@gg01:~>commit;

Commit complete.

查看目标端的replicat进程状态

GGSCI (gg02) 14> info ALL

Program     STATUS      GROUP       Lag           TIME Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    ABENDED     RORAJJ      00:00:00      00:00:09    

在目标端replicat加入解密参数

GGSCI (gg02) 3> VIEW params rorajj

REPLICAT RORAJJ
USERID system, PASSWORD oracle
HANDLECOLLISIONS
ASSUMETARGETDEFS
--解密参数
DECRYPTTRAIL
DISCARDFILE /u01/app/oracle/goldengate/dirrpt/RORAJJ.DSC, PURGE

DDL INCLUDE MAPPED
DDLOPTIONS REPORT

COLMATCH NAMES STUDENT_ID = STU_ID
COLMATCH NAMES STUDENT_NAME = STU_NAME
COLMATCH NAMES STUDENT_EMAIL = STU_EMAIL
COLMATCH PREFIX STU_

MAP scott.stu, TARGET scott.student, COLMAP (USEDEFAULTS);

COLMATCH RESET