1. Oracle GoldenGate Classic Documentation
  2. Instantiate
  3. Precise Instantiation for MySQL to MySQL Replication Using the Dump Utility
  4. Precise Instantiation for Oracle GoldenGate Extract for MySQL

Precise Instantiation for Oracle GoldenGate Extract for MySQL

The following steps describe precise instantiation for Extract in Oracle GoldenGate Classic Architecture:

  1. To test the precise instantiation on non-gtid-based capture, make sure either the gtid_mode is not enabled in the database server or _DISABLEGTIDRECOVERY true is specified in the Extract parameter file.

  2. After completing the initial load, use the instance dump.

  3. Read the @.json file and get the values of binlogFile and binlogPosition from the @.json file. Use these values as lognum and logpos.

  4. Add Extract using lognum and logpos in Oracle GoldenGate GGSCI, as shown in the following example:
    ADD EXTRACT extpos tranlog lognum 5 logpos 1289

  5. Perform the DML operations and verify that there are no duplicate or missing transactions on the target side. Check the Extract report file for the initial position using lognum and logpos.