Goldengate FORMAT RELEASE

Sometimes we meet OGG-01389 File header failed to parse tokens.

Source:ogg:11.2.1.0.1name:zbdba1target:ogg:11.1.1.1.2name:zbdba2

The version is not the same, causing the error.
Then we just need to add format release 11.1 to the extraction and delivery process.
Here's how:
Stop all extract and replicat processes
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   

Modify the parameters file for the extraction and delivery process:

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 O Bjtype ' FUNCTION ' &include MAPPED OBJTYPE ' package ' &include MAPPED OBJTYPE ' materialized VIEW ' &exclude Optyp E 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 1 1.1RMTTRAIL./dirdat/sa, format release 11.1table zbdba.*; 

Do not rush to start the process, because the previous trial file is version 11.2, this time the startup will appear the following error:

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.20 15-03-05 02:19:23  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, EXT2.PRM:  PROCESS abending.

Then we force the extraction process and the delivery process to switch to a new trail file:

Ggsci (ZBDBA1) 17> alter extract EXT1 etrollover2015-03-05 02:02:29  INFO    OGG-01520  Rollover performed.<  C3/>for Each affected output trail of Version 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 would 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 or higher format, after starting the source extract, issue ALTER extseqn O for that Trail's reader (either pump EXTRACT or Replicat) to move the reader's scan to the new trail file;  It would not happen automatically. EXTRACT altered. Ggsci (ZBDBA1) 43> alter extract ext2 extseqno  1EXTRACT altered.

To open the pumping process:

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   

To view logs:

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)], start SCN [1393784], commit SCN [1 393812] 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.

Discover now that the trail file version has changed

To turn on the replication process:

Ggsci (ZBDBA2) 1> info allprogram     Status      Group       Lag time           Since chkptmanager     RUNNING                                          Replicat    RUNNING     REP1        00:00:00      00:00:02     

Monitoring logs:

2015-03-05 02:20:02 INFO OGG-01669 Oracle GoldenGate collector:opening./dirdat/sa000002 (byte-1, current EOF 0). 2 015-03-05 02:21:19 INFO OGG-00482 Oracle GoldenGate Delivery for Oracle, Rep1.prm:DDL found, Operation [drop table Test (size)].2015-03-05 02:21:19 INFO OGG-00489 Oracle GoldenGate Delivery for Oracle, Rep1.prm:DDL is of Mappe D scope, after mapping new operation [drop table "Zbdba". " TEST "(size)].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 O  GG-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:2 3 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 Schem A for DDL operation to [OGG].

OK, everything is back to normal.

Goldengate FORMAT RELEASE