Identifying Lag in Replicat

To identify lag in Replicat process and modify columns of a table:

1. Suspend activity on the source database for all tables that are linked to Oracle GoldenGate.
2. Start Admin Client.
3. Run this command for the Replicat group:

   INFO REPLICAT group
   

4. On the Checkpoint Lag line, verify whether there is any Replicat lag. If needed, continue to issue INFO REPLICAT until lag is zero, which indicates that all of the data in the trail has been processed.
5. Stop the Replicat group.

   STOP REPLICAT group
   

6. Perform the table modifications on the target databases.
7. Start the Replicat process.

   START REPLICAT group
   

8. Allow user activity to resume on all of the source tables that are linked to Oracle GoldenGate.