To use the gtid set for precise instantion, make sure that the gtid_mode is enabled in the database server and _DISABLEGTIDRECOVERY true is not specified in the Extract parameter file. The gtid-based positioning does not work on non-gtid-based capture. The following steps describe how to set up precise instantiation for gtid-based capture:

1. Read the field value of gtidExecuted from the @.json file and use it as an initial position in the add extract tranlog gtid set gtid_set command.

2. Use this position in Oracle GoldenGate Microservices Admin Client and web interface, as shown in the following example:

   OGG (https://databasede3phx.oraclevcn.com:9011/ GTIDMAIN) 2> ADD EXTRACT longgtid, tranlog gtidset "1174b383-3441-11e8-b90a-c80aa9429920:1-9,\n1174b383-3441-11e8-b90a-c80aa9429921:1-9" 3

3. Start the Extract.

4. Verify in the Extract report file for INFO messages for the Initial GTID set and Position of first record processed. The Initial GTID set and Position of first record processed should contain the same gtid set that is used for the initial positioning.

5. Perform the DML operations and verify that there are no duplicate or missing transactions on the target side.