Goldengate FORMAT RELEASE

有时候我们会遇见 OGG-01389 File header failed to parse tokens.

Source:OGG:11.2.1.0.1Name:zbdba1Target:OGG:11.1.1.1.2Name:zbdba2

版本不一样，所以造成错误。
那么我们只需要在抽取和投递进程中加入format release 11.1 即可
具体操作如下：
停止所有的extract和replicat进程
Source:

GGSCI (zbdba1) 2> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     STOPPED                                          EXTRACT     STOPPED     EXT1        00:00:00      00:01:15   EXTRACT     STOPPED     EXT2        00:00:00      00:00:38    Target:GGSCI (zbdba2) 18> info allProgram     Status      Group       Lag           Time Since ChkptMANAGER     RUNNING                                          REPLICAT    STOPPED     REP1        00:00:00      00:04:38   

修改抽取和投递进程的参数文件：

Source:GGSCI (zbdba1) 2> view param ext1EXTRACT EXT1setenv ( NLS_LANG = AMERICAN_AMERICA.ZHS16GBK )USERID ogg,PASSWORD oggDDL &INCLUDE MAPPED OBJTYPE 'TABLE' &INCLUDE MAPPED OBJTYPE 'IDNEX' &INCLUDE MAPPED OBJTYPE 'SEQUENCE' &INCLUDE MAPPED OBJTYPE 'VIEW' &INCLUDE MAPPED OBJTYPE 'PROCEDURE' &INCLUDE MAPPED OBJTYPE 'FUNCTION' &INCLUDE MAPPED OBJTYPE 'PACKAGE' &INCLUDE MAPPED OBJTYPE 'MATERIALIZED VIEW' &EXCLUDE OPTYPE COMMENTDDLOPTIONS ADDTRANDATA NOCROSSRENAME REPORTREPORTCOUNT EVERY 1 MINUTES,RATEDISCARDFILE ./dirrpt/EXTSA.DSC,APPEND,MEGABYTES 1024THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 60000 IOLATENCY 60000DBOPTIONS ALLOWUNUSEDCOLUMNWARNLONGTRANS 2H,CHECKINTERVAL 3M--add format release 11.1exttrail ./dirdat/sa,format release 11.1FETCHOPTIONS NOUSESNAPSHOT,FETCHPKUPDATECOLS,MISSINGROW REPORTtable zbdba.*;GGSCI (zbdba1) 3> view param ext2EXTRACT EXT2passthruRMTHOST 192.168.56.61,MGRPORT 7839,COMPRESS--add format release 11.1RMTTRAIL ./dirdat/sa,format release 11.1table zbdba.*;

先别急着启动进程，因为以前的trial文件是11.2版本的，这时候启动会出现如下错误：

2015-03-05 02:19:23  ERROR   OGG-01411  Oracle GoldenGate Capture for Oracle, ext2.prm:  Cannot convert input file /ogg/dirdat/sa000000 with format RELEASE 11.2 to output file ./dirdat/sa000002 with format RELEASE 10.4/11.1.2015-03-05 02:19:23  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext2.prm:  PROCESS ABENDING.

那么我们迫使抽取进程和投递进程切换一个新的trail文件：

GGSCI (zbdba1) 17> alter extract ext1 etrollover2015-03-05 02:02:29  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.EXTRACT altered.GGSCI (zbdba1) 40> alter extract ext2 etrollover;2015-03-05 02:19:02  INFO    OGG-01520  Rollover performed.  For each affected output trail of Version 10 or higher format, after starting the source extract, issue ALTER EXTSEQNO for that trail's reader (either pump EXTRACT or REPLICAT) to move the reader's scan to the new trail file;  it will not happen automatically.EXTRACT altered.GGSCI (zbdba1) 43> alter extract ext2 extseqno  1EXTRACT altered.

开启抽进程：

GGSCI (zbdba1) 45> info allProgram     Status      Group       Lag at Chkpt  Time Since ChkptMANAGER     RUNNING                                          EXTRACT     RUNNING     EXT1        00:00:00      00:00:07   EXTRACT     RUNNING     EXT2        00:00:00      00:00:08   

查看日志：

opened).2015-03-05 02:20:03  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, ext2.prm:  Output file ./dirdat/sa is using format RELEASE 10.4/11.1.2015-03-05 02:21:18  INFO    OGG-01487  Oracle GoldenGate Capture for Oracle, ext1.prm:  DDL found, operation [drop table test  (size 16)], start SCN [1393784], commit SCN [1393812] instance [orcl11g (1)], DDL seqno [17501], marker seqno [16501].2015-03-05 02:21:18  INFO    OGG-00487  Oracle GoldenGate Capture for Oracle, ext1.prm:  DDL operation included [INCLUDE MAPPED OBJTYPE 'TABLE'], optype [DROP], objtype [TABLE], objowner [ZBDBA], objname [TEST].2015-03-05 02:21:18  INFO    OGG-00497  Oracle GoldenGate Capture for Oracle, ext1.prm:  Writing DDL operation to extract trail file.

发现现在的trail文件版本已经改变

开启复制进程：

GGSCI (zbdba2) 1> info allProgram     Status      Group       Lag           Time Since ChkptMANAGER     RUNNING                                          REPLICAT    RUNNING     REP1        00:00:00      00:00:02     

监控日志：

2015-03-05 02:20:02  INFO    OGG-01669  Oracle GoldenGate Collector:  Opening ./dirdat/sa000002 (byte -1, current EOF 0).2015-03-05 02:21:19  INFO    OGG-00482  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL found, operation [drop table test  (size 16)].2015-03-05 02:21:19  INFO    OGG-00489  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL is of mapped scope, after mapping new operation [drop table "ZBDBA"."TEST"  (size 26)].2015-03-05 02:21:19  INFO    OGG-00487  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL operation included [INCLUDE MAPPED], optype [DROP], objtype [TABLE], objowner [ZBDBA], objname [TEST].2015-03-05 02:21:19  INFO    OGG-01407  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Setting current schema for DDL operation to [ZBDBA].2015-03-05 02:21:19  INFO    OGG-00484  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Executing DDL operation.2015-03-05 02:21:23  INFO    OGG-00483  Oracle GoldenGate Delivery for Oracle, rep1.prm:  DDL operation successful.2015-03-05 02:21:23  INFO    OGG-01408  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Restoring current schema for DDL operation to [OGG].

ok,一切恢复正常。