This is just a quick note for those who are looking to using Oracle GoldenGate 12.3.0.1 (Classic or Microservices) and want to send trails of a lower version. This information can be found in the Release Notes for Oracle GoldenGate 12.3.0.1 (here).
The default behavior for FORMAT RELEASE settings supported with EXTTRAIL, RMTTRAIL, EXTFILE and RMTFILE has changed. This is due to changes need to support PDBs with Local Undos. The three bullet points below provide a summary of what has changed.
- Non-CDB databases with compatibility set to 12.1, FORMAT RELEASE 12.2 or above is supported.
- Non-CDB databases with compatibility set to 12.2, FORMAT RELEASE 12.2 or above is supported.
- CDB/PDB databases with compatibility set to 12.2, only FORMAT RELEASE 12.3 is supported. This is due to the use of local undo for PDBs, which requires augmenting the transaction ID with the PDB number to ensure uniqueness of trx IDs.
Enjoy!!!
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
I’ve been exploring for a bit for any high-quality articles or weblog posts in this kind
of house . Exploring in Yahoo I finally stumbled upon this website.
Reading this info So i’m happy to exhibit that I’ve a very just right
uncanny feeling I discovered exactly what I needed. I most undoubtedly will make certain to don?t overlook this
web site and give it a glance on a relentless
basis.
Hmm is anyone else having problems with the pictures on this blog
loading? I’m trying to determine if its a problem
on my end or if it’s the blog. Any feed-back would be greatly
appreciated.
There is definately a lot to know about this issue.
I really like all the points you have made.