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 REPFINUsing combined management, you can start both modules with a single command, as in:
GGSCI> START ER *FINSyntax
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, REPORTThe 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 *FINoption
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, DOWNFor details about the options, see the command’s description in “Extract commands” or “Replicat commands”.
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: 0The 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: 1The 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