1.9 Remote checkpoint commands

Use REMOTECHKPT when both of the following apply:

  • The Manager process is configured to perform local trail maintenance using checkpoints

  • The local trail is being processed by programs on remote systems

If the PURGEOLDEXTRACTS parameter is set, Manager periodically examines checkpoint files and purges files that satisfy the rules of the PURGEOLDEXTRACTS parameter.

1.9.1 ADD REMOTECHKPT

Use ADD REMOTECHKPT to tell Manager where to find checkpoints for Extract or Replicat processes running on remote systems. The Replicat checkpoint file is called REPCTXT and exists in the same subvolume where Oracle GoldenGate is installed, as in:

ADD REMOTECHKPT \NY.$DATA5.GGS.REPCTXT

Syntax

ADD REMOTECHKPT checkpoint_file
checkpoint_file

The checkpoint file to examine. The file name must include the remote node name.

1.9.2 DELETE REMOTECHKPT

DELETE REMOTECHKPT deletes a remote checkpoint reference.

Syntax

DELETE REMOTECHKPT checkpoint_file
checkpoint_file

The checkpoint file to examine.

1.9.3 INFO REMOTECHKPT

INFO REMOTECHKPT lists all remote checkpoint references.

Syntax

INFO REMOTECHKPT checkpoint_file
checkpoint_file

The checkpoint file to examine. You can specify a wildcard, as in INFO REMOTECHKPT *.