Oracle goldengate Encrypt TRAIL File using ENCRYPTTRAIL parameter

 

https://docs.oracle.com/en/middleware/goldengate/core/21.3/reference/encrypttrail-noencrypttrail.html#GUID-F9C77C5E-500A-4B1D-9326-8385EECE531D

 ENCRYPTTRAIL and NOENCRYPTTRAIL parameters are used to enable/disable encryption on OGG TRAIL files

      1.      Wallet (or)  master key Method

      2.     ENCKEY Method

Extract param: (wallet method)

For wallet method you need to create wallets before using the ENCRYPTTRAIL in extract

 GGSCI (oracledev) 5> view params EXT

EXTRACT ext

INCLUDE /tmp/GG_ENV.mac

#E_GG_env()

GETUPDATEBEFORES

NOCOMPRESSDELETES

NOCOMPRESSUPDATES

REPORTCOUNT EVERY 1 HOUR, RATE

WARNLONGTRANS 1D, CHECKINTERVAL 10M, SKIPEMPTYTRANS

EXTTRAIL <path>/aa

TABLE SCOTT.EMPL GETBEFORECOLS(ON UPDATE ALL, ON DELETE ALL) ;

 

$ cat /goldengate/home/GG_ENV.mac

MACRO #E_GG_env

BEGIN
SETENV (ORACLE_HOME='/u01/app/oracle/product/19.0.0.0/dbhome_1')
SETENV (ORACLE_SID='oradb1')
USERIDALIAS ggadmin_dev
ENCRYPTTRAIL
END;

Reference:

How to Encrypt/Decrypt Oracle GoldenGate Trail File (Doc ID 1287578.1)
How to Use ENCRYPTTRAIL and DECRYPTTRAIL Parameters in Extract, Pump and Replicat (Doc ID 1397104.1)