Add a Replicat
Learn about the prerequisites to add a Replicat, select the approriate Replicat type, and the steps to add a Replicat.
Before you Add a Replicat
Before you add a Replicat, add a checkpoint table. After you connect to the database, you can create the checkpoint table by following these steps:
-
From the Administration Service, go the Configuration page using the navigation pane.
-
Click the + sign next to the Checkpoint section on the Database tab.
-
Enter the checkpoint table name in the Checkpoint Table box. The table name must be a two-part or three-part value. For example,
ggadmin.ggs_checkpointtable
.
You can add the checkpoint table using the ADD
CHECKPOINTTABLE
command from the Admin Client.
Add a Checkpoint Table
Not valid for Replicat for Java, Oracle GoldenGate Applications Adapter, or Oracle GoldenGate for Big Data.
Use ADD CHECKPOINTTABLE
to create a checkpoint table in the target database. Replicat uses the table to maintain a record of its read position in the trail for recovery purposes.
The use of a checkpoint table is strongly recommended, because it causes checkpoints to be part of the Replicat transaction. This allows Replicat to recover more easily in certain circumstances than when a checkpoint file alone is used. Parallel and Coordinated Replicats require checkpoint tables.
One table can serve as the default checkpoint table for all Replicat groups in an Oracle GoldenGate instance if you specify it with the CHECKPOINTTABLE
parameter in a GLOBALS
file. More than one instance of Oracle GoldenGate (multiple installations) can use the same checkpoint table. Oracle GoldenGate keeps track of the checkpoints even when the same Replicat group name exists in different instances.
Use the DBLOGIN
command to establish a database connection before using this command. Do not change the names or attributes of the columns in this table. You may, however, change table storage attributes.
Admin Client Syntax
ADD CHECKPOINTTABLE [[container. | catalog.] owner.table]
The name cannot contain any special characters, such as quotes, backslash, dollar sign, and percent symbol. Record the name of the table, because you need it to view statistics or delete the table if needed.
The owner and name can be omitted if you are using this table as the default checkpoint table and it is listed with CHECKPOINTTABLE
in the GLOBALS
file. It is recommended, but not required, that the table be created in a schema dedicated to Oracle GoldenGate. If an owner and name are not specified, a default table is created based on the CHECKPOINTTABLE
parameter in the GLOBALS
parameter file.
Record the name of the table, because you will need it to view statistics or delete the table if needed.
Record the name of the checkpoint table as that will be used when you add a
Replicat, or delete a Replicat and need to drop the checkpoint table using the DELETE CHECKPOINTTABLE
command.
The default schema for the checkpoint table is controlled by the Oracle GoldenGate user that is defined for each deployment.
Examples
The following adds a checkpoint table with the default name specified in the GLOBALS
file.
ADD CHECKPOINTTABLE
The following adds a checkpoint table with a user-defined name.
ADD CHECKPOINTTABLE ggadmin.ggs_checkpointtable
Add a Replicat
You can add Replicats for the target deployment from the Administration Service. Make sure that you have configured your deployments correctly, checked your database credentials, and created an Extract before you set up your Replicat. For details, see Manage Deployments from the Service Manager. Once you’ve set up your source and target deployment, you can create and run the Replicat by following these steps: