INFO ER

Use the INFO ER command to get information on multiple Extract and Replicat groups as a unit. Use it with wildcards to affect every Extract and Replicat group that satisfies the wildcard. This information is returned:

• The status of Extract (STARTING, RUNNING, STOPPED or ABENDED). STARTING means that the process has started but has not yet locked the checkpoint file for processing.

• Approximate Extract lag.

• Checkpoint information.

• Process run history.

• The trails to which Extract is writing.

• Status of upgrade to, or downgrade from, integrated capture. The process can be running or stopped when INFO ER is issued. With a running process, the status of RUNNING can mean one of the following:

• Active: Running and processing (or able to process) data. This is the normal state of a process after it is started.

• Suspended: The process is running, but suspended due to an EVENTACTIONS SUSPEND action. In a suspended state, the process is not active, and no data can be processed, but the state of the current run is preserved and can be continued by issuing the SEND command with the RESUME option. The RBA in the INFO command reflects the last checkpointed position before the suspend action. To determine whether the state is active or suspended, issue the SEND command with the STATUS option.

Syntax

INFO ER *group_wildcard*
[, SHOWCH *checkpoints-number*]
[, DETAIL]
[, TASKS]
[, ALLPROCESSES]

group_wildcard

The wildcard specification for the groups that you want to affect with the command. Oracle GoldenGate automatically increases internal storage to track up to 100,000 wildcard entries.

SHOWCH checkpoint-number

The basic command shows information about the current Extract checkpoints. Extract checkpoint positions are composed of read checkpoints in the data source and write checkpoints in the trail. The trail type, EXTTRAIL is also noted.

Optionally, specify a value for checkpoint number to include the specified number of previous checkpoints as well as the current one.

Note: You might see irregular indents and spacing in the output. This is normal and does not affect the accuracy of the information.

DETAIL

Displays the Extract run history, including start and stop points in the data source expressed as a time and the trails to which Extract is writing.

TASKS

Displays Extract tasks only. Tasks that were specified by a wildcard argument are not displayed by INFO EXTRACT.

ALLPROCESSES

Displays all Extract groups, including tasks.

Example

INFO ER *

Output would be similar to the following:

Extract    EXTE      Last Started 2022-06-07 07:33   Status RUNNING
Description          east
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Process ID           60782
Log Read Checkpoint  Oracle Integrated Redo Logs
                     2022-09-05 23:17:19
                     SCN 0.89996333 (89996333)
Settings Profile     Default
Encryption Profile   LocalWallet


Replicat   REPE      Last Started 2022-06-15 03:45   Status RUNNING
Description          east
INTEGRATED
Parallel
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Process ID           96740
Log Read Checkpoint  File east/ea000000009
                     2022-09-05 23:17:19.808198  RBA 9382
Settings Profile     Default
Encryption Profile   LocalWallet