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
  • Hmm it appears like your blog ate my first comment (it was extremely long) so
    I guess I’ll just sum it up what I had written and say,
    I’m thoroughly enjoying your blog. I too am an aspiring blog writer but I’m still new to the whole
    thing. Do you have any points for inexperienced blog writers?
    I’d certainly appreciate it.

  • Hi! I could have sworn I’ve been to this site before but after
    reading through some of the post I realized it’s new to me.
    Anyhow, I’m definitely happy I found it and I’ll be book-marking and checking back frequently!

    Here is my webpage :: vpn

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.