ADD CHECKPOINTTABLE
Not valid for Replicat for Java, Oracle GoldenGate Applications Adapter, or Oracle GoldenGate for Big Data.
Valid for non-parallel Replicats.
For a parallel Replicat, the checkpoint table is created as part of the command to add the parallel Replicat and does not require that the checkpoint table be created before adding the parallel Replicat.
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.
See About Checkpoints.
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.
-
container.
|
catalog
. -
The Oracle pluggable database, if applicable. If this option is omitted, the pluggable database defaults to the one that is associated with the
SOURCEDB
,USERID
, orUSERIDALIAS
portion of theDBLOGIN
command (depending on the database). -
owner.table
-
The owner and name of the checkpoint table to be created. The name cannot contain any special characters, such as quotes, backslash, dollar sign, and percent symbol.
The name of a MySQL checkpoint table can contain no more than 58 characters.
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 theGLOBALS
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 theGLOBALS
parameter file.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.In MA, the default schema for the checkpoint table is controlled by the Oracle GoldenGate user that is defined for each deployment. See Replication Settings.
Parent topic: Admin Client Command Line Interface Commands