OGG-06221 Source Container Database Requires Trail FORMAT 12.3 or Higher
Last updated on OCTOBER 11, 2017
Applies to:Oracle GoldenGate - Version 12.3 Beta and later
Information in this document applies to any platform.
Source: Oracle Database 184.108.40.206.0 Multitenant - OGG version 12.3
Target: Oracle Database 220.127.116.11 - OGG version 12.2
Classic Replicat would abend with following message since Source version is higher
2017-10-04 20:56:16 ERROR OGG-01332 File ./dirdat/HIPOS/mb000000001, with compatibility level 6, is not compatible with the current software version's compatibility level of 5. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 5 option.
Classic Extract and Pump configuration was changed on source to change the trail format to 12.2 so that Replicat doesn't error.
Extract <Extract name>
EXTTRAIL ./dirdat/ea, FORMAT RELEASE 12.2
RMTTRAIL ./dirdat/ra, FORMAT RELEASE 12.2
However doing so leads to following issues
1) Extract would error with following
OGG-06221 Source container database requires trail FORMAT 12.3 or higher.
2) Pump would run fine although trail format still remains in 12.3 since Source Extract never was never able to convert the format to 12.2
INFO OGG-01478 Output file ./dirdat/HIPOS/mb is using format RELEASE 12.3.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms