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".

1.4.1 SEND ER* STATS

Use the following commands to get process status from Extract and Replicat, as in:

Syntax

SEND [EXTRACT | REPLICAT] group_name, 
STATS [time_option [RESET | FILE name | TABLE name]]

group_name

The group name you defined with the appropriate GGSCI ADD command

STATS time_option [RESET | FILE name | TABLE name

Returns Extract and Replicat processing statistics based on the selected options.

RESET

This resets the time_option counters to zero. For example, the command SEND RECENT RESET will report the RECENT counters and then reset them to zero.

FILE name | TABLE name

This limits the display to statistics for the file or table specified in name.

time_option

Each of these returns processing statistics for the specified process. TRANSACTION is valid only for Replicat.

TOTALS: since the Extract or Replicat was started

DAILY: since the beginning of the current day

HOURLY: since the beginning of the current hour

RECENT: since the last time the RECENT counter was reset

TRANSACTION: since the beginning of the current transaction

Examples

The following sample Extract report uses the default STATS option.

Report at 2010-02-27 12:43:07 (activity since 2010-02-27 11:43:44)
Elapsed time 0-00:59:22.916658
Total # records written to \NODEA.$TEST04.GGSDAT.ET                19
   \NODEA.$TEST04.GGSSOU.TCUSTMER            #  inserts:            3
                                             #  updates:            0
                                             #  deletes:            0
   \NODEA.$TEST04.GGSSOU.TCUSTORD            #  inserts:            3
                                             #  updates:           13
                                             #  deletes:            0

The next sample Extract report uses the following options.

TOTALS statistics since 2018-07-12 10:37:53             
				#  inserts:         1           
				# purgedatas:         1 
DAILY  statistics since 2018-07-12 10:37:53             
				#  inserts:         1          
				 # purgedatas:         1 
HOURLY statistics since 2018-07-12 10:59:59             
				#  inserts:         1           
				# purgedatas:         1 
RECENT statistics since 2018-07-12 10:37:53             
				#  inserts:         1           
				# purgedatas:         1 

The following Replicat report uses the TRANSACTION option.

Report at 2010-02-28 06:51:15 counters for TRANS since 2010-02-14 13:46:54
Elapsed time 13-17:04:21.290242
From \A.$TEST04.GGSSOU.ECUSTMER to \A.$TEST04.GGSTAR.HCUSTMER:
            #  inserts:         3
            #  updates:         1
            #  deletes:         0
            # discards:         0
From \A.$TEST04.GGSSOU.ECUSTORD to \A.$TEST04.GGSTAR.HCUSTORD:
            #  inserts:         3
            #  updates:         3
            #  deletes:         2
            # discards:         0