1.源頭OGG版本低,目的端OGG版本高,此種配置不需要做任何的額外改動.跟兩端是相同OGG版本的同步是完全一樣的引數設定.

2.源頭OGG版本高,目的端OGG版本低,此種配置需要在源頭的抽取程式和傳輸程式的引數檔案中設定trailfile的格式(設定為跟目的端OGG版本一樣的格式).

EXTTRAIL <trail file>, FORMAT RELEASE 10.0

RMTTRAIL <trail file>, FORMAT RELEASE 10.0

注意:此處的10.0是目的端OGG的版本號.

3.源頭的抽取程式和傳輸程式的引數檔案中務必都要設定trailfile的格式.因為,僅僅依靠傳輸程式無法達到轉換trailfile格式的目的.因為傳輸程式就是這麼設計的:It must write trails in the same version it read them.

參考文章:
different versions of golden gate (社群論壇 ID 3570021)
Can OGG Version 11 Be Used to Pump/Move Trails Generated from Version 9 or 10? (文件 ID 1297283.1)

In this Document

APPLIES TO:

GOAL

Can Oracle GoldenGate version 11 Extract be used to pump/move trail files which were generated from version 9 or 10 to another server?

SOLUTION

Oracle GoldenGate version 11.1 can read versions 9 and version 10 trail files but it can not write them in a different format (version 11.1) than the version of the trail being read. It must write trails in the same version it read them. The extract can be forced to write a trail in a particular version format by using the FORMAT RELEASE option.

Example:

RMTTRAIL <trail file>, FORMAT RELEASE 10.0