- Access Rule Restriction - secures your Oracle GoldenGate replication by preventing unauthorized access to Oracle GoldenGate Manager processes and the processes under its control. You need to install Oracle GoldenGate with 12.1.2.1.10+ and 12.2+ versions to get this feature. (Blog - Oracle GoldenGate Security: ACCESSRULE provides the details.)
- Automatic Heartbeat Table - provides built-in support for heartbeat tables and enables the end-to-end monitoring of the lag time.
- Metadata in Trail File - removes the need to use defgen or use the SOURCEDEFS/ASSUMETARGETDEFS parameter.
- Parameter Insight - allows you to look up parameter definitions from GGSCI with INFO PARAM, get the list of running
parameters for a process with SEND … GETPARAMINFO. You can also use the new checkprm utility to pre-validate parameter files. - One Billion Trail Files - Trail file sequence length has increased to nine digits; a 1000x increase and effectively one billion trail files.
- Table-Level Character Set Encoding: each table can have a different encoding[1]. Oracle GoldenGate 12.2 keeps the table-level encoding unchanged during the replication. The replication performance is improved by avoiding character set conversions.
- For DB2 for LUW,
- Temporal Columns/Tables - are new in DB2 LUW 10.1 (DB2 LUW 10.1 FixPack 2 and greater are supported) . The feature is called "time travel query" based on SQL:2011 standard. Oracle GoldenGate for DB2 LUW 12.2 by default support replicating all of the following temporal tables: Application-period temporal table, System period temporal table and Bitemporal table. (Blog - What's New in Oracle GoldenGate for DB2 LUW 12.2)
- Certified on DB2 for LUW 11.1 - For DB2 for z/OS, (Blog - Oracle GoldenGate for DB2 z/OS 12.2.0.1.2 New Features)
- Certified on z/OS 2.2 - For DB2 for i Series (added also in 12.1 Blog - Oracle GoldenGate for DB2 for i 12.2.1.0.2 Release)
- Support Multi-Journals, Native Name Handling and Partitioned Tables
- Certified on IBM iSeries 7.2 - For SQL Server
- Support Remote ALO mode Capture
- SQL Server Standard Edition Capture and Delivery
- SQL Server 2014 Compressed Log backups
- Oracle GoldenGate 12.2 New Features Deep Dive - OpenWorld Session 2015
- Oracle GoldenGate 12.2 Release - Oracle Integration Blog, February 1, 2016
- Oracle GoldenGate 12.2.0.1 Release Notes