1.4 ER commands

Oracle GoldenGate lets you manage Extract and Replicat as a unit with a single command. For example, to start the modules separately for group FINANCE, you would normally enter commands similar to:

GGSCI> START EXTRACT EXTFIN
GGSCI> START REPLICAT REPFIN

Using combined management, you can start both modules with a single command, as in:

GGSCI> START ER *FIN

Syntax

command ER group_name [, option]

command

Any one of the following:

INFO

Returns the processing status of both modules, including lag information

KILL

Forces the processes to stop immediately. Oracle GoldenGate recommends first attempting to stop processes using the STOP command. Either KILL or STOP is preferred over stopping processes from TACL.

SEND

Sends a performance option to the programs, such as REPORT.

SEND ER *FIN, REPORT

The REPORT option generates an interim statistical report to the report files.

START

Begins the programs. Manager receives the START command and starts and monitors the programs.

STATUS

Determines whether the processes are running.

STOP

Causes a graceful stop, ensuring configuration changes can be made without impacting future runs.

For more information about these commands, see the command's description in "Extract commands" or "Replicat commands".

ER

Required. Informs Oracle GoldenGate that the command applies to both of the programs.

group_name

The Extract or Replicat group name. You can use wildcard specifications. The following commands act upon any group containing the characters FIN.

START ER *FIN*
START ER FIN*
START ER *FIN

option

Can be any option associated with the command, such as the INFO command DOWN option, which shows only processes that are not running, as in:

INFO ER *FIN, DOWN

For details about the options, see the command's description in "Extract commands" or "Replicat commands".