GoldenGate 12.2 – New Features (Oracle Open World 2015)

Today I attended a “deep dive” session on GoldenGate 12.2 new features, and I really cannot wait for this version to be released!


No more definitions files.  Oracle are removing the need for definitions files (and therefore the SOURCEDEFS and ASSUMETARGETDEFS parameters).  They’re achieving this by building information about the table definition straight into the trail file.  Rather than increasing the size of the trail, Oracle are saying this very slightly decreases the size since they don’t need to keep recording the table name for each record.  This feature simplifies DDL replication, particularly if there are table definition differences between the source and target.  Logdump has been modified to provide this additional information.

Automatic Heartbeat Table.  Until now, Oracle have provided a “best practice” document with suggested SQL and code on how to produce a heartbeat table within GoldenGate configuration.  This allows you to monitor the various processes and the lag between the various sites.  This is now built into the product and can be configured with a single command.  It creates the heartbeat table on both sites, gets updated (by default) every 60 seconds and breaks down the lag even to a process level so you can see Extract, Replicat and Pump lag.  It even stores historical information to a separate table for reporting later.

Validation of parameter files.  GoldenGate now ships with “checkprm” – a utility that allows you to validate the parameters used within the configuration.  Any problems will be flagged without the need to iteratively resolve configuration problems at process startup time.  Not particularly exciting, but a nice little utility regardless!

Viewing parameters.  You can now view query the running GoldenGate parameters from running processes rather than viewing the report file or parameter file.  Again, not particularly exciting but apparently it paves the way for dynamically modifying parameters without the need to stop/start processes which will be a welcome enhancement.

CRS Integration.  Makes it easier to configure GoldenGate high availability and Manager process startup/shutdown.  Uses new XAG_ENABLE parameters as well as the AGCTL utility.

Data Pump enhancements.  GoldenGate and Data Pump are now much more aware of each other and using ENABLE_INSTANTIATION_FILTERING parameters means that you can quickly instantiate a table using Data Pump without having to use the “start at CSN” options.  Replicat will know which records need to be applied from the trail file automatically.  Anyone used to working on GoldenGate will have already got their heads around how and where to start replication within a trail file during instantiation, but this feature will make it much easier for GoldenGate beginners to build their target site.

Trail Recovery.  This is another really nice feature – GoldenGate automatically detects trail file corruption and takes corrective action itself.  If replicat detects corruption, it deletes the entire corrupt trail file.  The Pump process will automatically detect a gap in the target trail, and regenerate new trail files on the target side – hopefully this time without corruption!  Replicat will automatically figure out where in the trail it needs to restart the apply process.  This is going to be a huge time saver in the inevitable cases where some problem such as file systems filling up cause corruption in the trail.

A few other miscellaneous enhancements were mentioned such as a new 9 digit trail file format (more time before rolling over is necessary) and support for invisible columns.

Super excited to get my hands on this version and get customers using it!

Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: