capabilities.work

Create and Start Replicat With Checkpoint

A 3-step recipe with Oracle GoldenGate. We can help you get access.

Recipe · 3 steps

Create and Start Replicat With Checkpoint

Register a credential, create a checkpointed Replicat, and start it.

  1. Create the credential alias the Replicat will use to connect to the target.
  2. Create a parallel Replicat bound to the credential alias, the source trail, and the checkpoint table.
  3. Issue a START command to the newly created Replicat process.
What you'll need to have ready
  • authorization: HTTP Basic Authorization header value.
  • domain: Credential store domain name.
  • alias: Credential alias to create.
  • userid: Database user ID including connect string.
  • password: Password for the database user.
  • replicat: Name of the Replicat process to create.
  • trail: Source trail file prefix the Replicat reads from.
  • checkpointTable: Checkpoint table in schema.table form.
  • config: Replicat parameter file content lines.
For your developer

Arazzo workflow oracle-goldengate:create-and-start-replicat-with-checkpoint, 3 operations: createCredentialAlias → createReplicat → issueReplicatCommand. Specs on APIs.io.