OGG-02913 Metadata format of the definitions file for table ＜schema＞.＜Table＞ does not match trail f

Ogg replicat - ERROR OGG-02913 Metadata format of the definitions file for table <schema>.<Table> does not match trail format. (Doc ID 2603896.1)

Oracle GoldenGate Application Adapters - Version 12.3 and later
Information in this document applies to any platform.

SYMPTOMS

Source -- ogg v12.3.x

target -- oggbd v12.3.x

The source was earlier with ogg v12.1.x and recently upgraded to ogg v12.3.x

ogg v12.3.x replicat was configured to read from a old trail file which was been generated when the source was ogg v12.1.x.

The replicat was using sourcedefs file but the replicat failed with error

ERROR OGG-02913 Metadata format of the definitions file for table <schema>.<Table> does not match trail format.

CHANGES

CAUSE

 The definition file was generated after ogg source was upgraded to ogg v12.3.x 

SOLUTION

The solution was to generate the defgen file in the source using  'FORMAT RELEASE 12.1'

In defgen.prm

DEFSFILE ./dirdef/< file name>.def FORMAT RELEASE 12.1

Userid < username>, password < PWD>

table < schema>.<table1>;

Table <schema>.<table2>;

Now run the defgen

./defgen paramfile ./dirprm/defgen.prm

Now transfer this file to the target machine and use this definition file as sourcedefs in the replicat.

Now start the replicat and it will be able to consume trail files written by the source ogg v12.1.x extract earlier.

最后

以上就是坦率火龙果为你收集整理的OGG-02913 Metadata format of the definitions file for table ＜schema＞.＜Table＞ does not match trail f的全部内容，希望文章能够帮你解决OGG-02913 Metadata format of the definitions file for table ＜schema＞.＜Table＞ does not match trail f所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。