Oracle GoldenGate Trail file encryption

来源：互联网发布：淘宝天刀代购编辑：程序博客网时间：2024/05/16 07:25

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

源端extract参数

GGSCI (gg01) 5> VIEW params eorajjEXTRACT EORAJJUSERID system, PASSWORD oracleRMTHOST gg02, MGRPORT 7809--加密参数ENCRYPTTRAILRMTTRAIL /u01/app/oracle/goldengate/dirdat/jjDDL INCLUDE ALLDDLOPTIONS ADDTRANDATA,REPORTTRANLOGOPTIONS CONVERTUCS2CLOBSTABLE 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 ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           REPLICAT    ABENDED     RORAJJ      00:00:00      00:00:09

在目标端replicat加入解密参数

GGSCI (gg02) 3> VIEW params rorajjREPLICAT RORAJJUSERID system, PASSWORD oracleHANDLECOLLISIONSASSUMETARGETDEFS--解密参数DECRYPTTRAILDISCARDFILE /u01/app/oracle/goldengate/dirrpt/RORAJJ.DSC, PURGEDDL INCLUDE MAPPEDDDLOPTIONS REPORTCOLMATCH NAMES STUDENT_ID = STU_IDCOLMATCH NAMES STUDENT_NAME = STU_NAMECOLMATCH NAMES STUDENT_EMAIL = STU_EMAILCOLMATCH PREFIX STU_MAP scott.stu, TARGET scott.student, COLMAP (USEDEFAULTS);COLMATCH RESET