FORMAT RELASE changes in #GoldenGate #12.3

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!!!

Please follow and like:
Comments
  • I’d like to thank you for the efforts you have put in penning this blog.

    I really hope to view the same high-grade blog posts from you later on as well.
    In truth, your creative writing abilities has inspired me to get my very
    own website now 😉

  • Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my newest
    twitter updates. I’ve been looking for a plug-in like this
    for quite some time and was hoping maybe you would have some
    experience with something like this. Please let me know if you run into anything.
    I truly enjoy reading your blog and I look forward to your new updates.

  • Write more, thats all I have to say. Literally, it seems as
    though you relied on the video to make your point.
    You definitely know what youre talking about, why waste your intelligence on just posting videos to
    your blog when you could be giving us something informative to read?

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.