2 What’s New in this Release

This chapter describes the features, enhancements, and changes made to Oracle GoldenGate. Oracle updates the release notes periodically after the software release. This document is accurate at the time of publication.

• New Features
  
• Default Behavior Changes
  
• Deprecated Features
  

2.1 New Features

This section describes the features and enhancements made to Oracle GoldenGate.

• Release 18c (18.1.0) - January 2019
  
• Release 18c (18.1.0) - October 2018 Initial Release
  

2.1.1 Release 18c (18.1.0) - January 2019

Teradata

Replicat is supported against Teradata 16.20.

MySQL

Remote MySQL capture allows for Oracle GoldenGate to be installed on a certified Linux x64 hub server and remotely capture from MySQL 5.6+ running on Linux or Windows.

2.1.2 Release 18c (18.1.0) - October 2018 Initial Release

Oracle Database

Capture (Extract) and Apply (Replicat) is supported against Oracle Database 18c.

Identity Columns are Supported

Oracle Database 18c and later support replication of identity columns. It requires usage of the Integrated Extract and Integrated Replicat or Integrated Parallel Replicat.

Replication of In-Database Archival

Replication for tables with row archival enabled is supported for Oracle Database 18c onward. The trail format must be 12.3 or higher.

Automatic CDR on tables with Unique Keys (UK)

Oracle Database 18c and later supports Automatic Conflict Detection and Resolution (CDR) on tables with Unique Keys with at least 1 non-null column.

Composite Sharding

Oracle Database 18c and later support composite sharding.

DB2 for z/OS

Improved Extract Throughput

Extract throughput has been enhanced by taking better advantage of available communication bandwidth.

Database Supported

DB2 for z/OS version 12.1 is now supported.

Reduced DB2 for z/OS ECSA Requirements

ECSA requirements have been reduced to a fixed value of 68KB per running Extract. In prior Oracle GoldenGate releases, ECSA varied depending on the setting of the TRANLOGOPTIONS BUFSIZE parameter.

TIMESTAMP Data Type Enhancements

TIMESTAMP with TIMEZONE is now supported and theTIMESTAMP precision has been increased to a maximum of 9.

Extract Flexibility

Configurable schema for the Extract stored procedure or user-defined table function used by the Oracle GoldenGate Extract.

DB2 LUW

TRANLOGOPTIONS MIXEDENDIAN[ON|OFF]

Oracle GoldenGate Extract for DB2 LUW now supports cross-endian capture where the database and Oracle GoldenGate are running on different byte order servers.

TRANLOGOPTIONS DB2APIRETRY retry_count

This is a new option that allows you to change number of times the DB2 log reading API db2ReadLog() is retried when it returns certain errors.

Support for PureScale

Oracle GoldenGate can capture from DB2 LUW PureScale.

TIMESTAMP datatype Enhancement

TIMESTAMP precision increased to a maximum of 9.

MySQL

Remote Capture Support

Oracle GoldenGate supports remote capture for Linux x64-bit, however, it’s not available on Windows. Remote capture and delivery is also supported for Amazon Aurora MySQL 5.7+ and Amazon RDS for MySQL.

MariaDB Capture and Delivery Support

Capture and Delivery is supported for MariaDB 10.2+.

2.2 Default Behavior Changes

This section describes the default behavior changes made to Oracle GoldenGate in relation to the last release.

• Release 18c (18.1.0) - October 2018 Initial Release
  

2.2.1 Release 18c (18.1.0) - October 2018 Initial Release

FORMAT RELEASE is Supported for Oracle GoldenGate 18c

You can use the value 18.1 with FORMAT RELEASE for EXTTRAIL and RMTTRAIL commands.

Performance Monitoring can be Designated as a Critical Service

Users can now designate Performance Monitor as a Critical Service and specify the location for the associated BDB/LMDB database.

2.3 Deprecated Features

This section describes the deprecated and no longer supported features of Oracle GoldenGate.

• Release 18c (18.1.0) - February 2019
  
• Release 18c (18.1.0) - October 2018 Initial Release
  

2.3.1 Release 18c (18.1.0) - February 2019

GENLOADFILES support in Oracle GoldenGate

The GENLOADFILES parameter is deprecated from Oracle GoldenGate 12.1 and higher.

2.3.2 Release 18c (18.1.0) - October 2018 Initial Release

Oracle Database

The Classic Extract (capture) is deprecated as of Oracle GoldenGate 18c (18.1.0). This means that there will be no further enhancements to the Classic Capture (Extract) process.