1 person found this helpful
Firstly, having source OGG upgraded to higher version when compared to target OGG version is not recommended. You can have higher version of OGG in target but not in source.
For your requirement, check the below,
Can We Use Format Release 12.2/12.1 in Goldengate 12.3 for Oracle Container Database (Doc ID 2325112.1)
I would request you to upgrade both Source and Target to OGG 19c if possible.
The best option is for you to upgrade both Source and Target OGG to 19c.
Having said that, Yes, Format release is supported in 19c OGG
But Please note that this is dependent on your source DB version as well. If source is a multitenant DB, you will not be able to use format release 11.2
eg: If you're source is Oracle 19c DB, you need to have the source trails in 19c format, you cannot use format release 11.2
What is your source DB version ?
The short answer is no. From 12.3 and obviously 19c, OGG extracts do not write version 11 or 12 trails for that matter. See https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/exttrail.html#GUID-6472A821-9470-4C83-A524-229BBC2F…
Generally, you upgrade a destination first as higher versions of OGG supports lower trail versions, as with most software. The fact that you are running version 11 on the target suggests that your DB is version 11 or non-PDB 12.
If you need your target to be version 11, for example, an old application that is going away soon, use a non-Oracle replication product. There are quite a few out there.