Use ADD REPLICAT
to create a Replicat group. Unless SPECIALRUN
is specified, ADD REPLICAT
creates an online process group that creates checkpoints so that processing continuity is maintained from run to run.
This command cannot exceed 500 bytes in size for all keywords and input, including any text that you enter for the DESC
option.
Oracle GoldenGate supports up to 5,000 concurrent Extract and Replicat groups per instance of Oracle GoldenGate Manager. At the supported level, all groups can be controlled and viewed in full with GGSCI commands such as the INFO
and STATUS
commands. Oracle GoldenGate recommends keeping the number of Extract and Replicat groups (combined) at the default level of 300 or below in order to manage your environment effectively.
(Oracle) Unless the INTEGRATED
option is used, this command creates a Replicat group in non-integrated mode. For more information about Replicat modes, see "Deciding Which Apply Method to Use" in Installing and Configuring Oracle GoldenGate for Oracle Database and "BATCHSQL".
Syntax
ADD REPLICAT group_name [, INTEGRATED | COORDINATED [MAXTHREADS number]] {, SPECIALRUN | , EXTFILE file_name | , EXTTRAIL trail_name} [, BEGIN {NOW | yyyy-mm-dd[ hh:mm[:ss[.cccccc]]]} | , EXTSEQNO sequence_number, EXTRBA rba] {, CHECKPOINTTABLE owner.table | NODBCHECKPOINT} [, PARAMS file_name] [, REPORT file_name] [, DESC 'description'] [, CPU number] [, PRI number] [, HOMETERM device_name] [, PROCESSNAME process_name]
group_name
The name of the Replicat group. The name of a coordinated Replicat group can contain a maximum of five characters. The name of a regular Replicat group can contain up to eight characters. See Administering Oracle GoldenGate for Windows and UNIX for more information about naming conventions for process groups.
INTEGRATED
(Oracle) Creates the Replicat in integrated mode. Without this option, ADD REPLICAT
creates the Replicat in non-integrated (classic) mode. In this mode, the Replicat process leverages the apply processing functionality that is available within the Oracle database. In this mode, Replicat operates as follows:
Reads the Oracle GoldenGate trail.
Performs data filtering, mapping, and conversion.
Constructs logical change records (LCR) that represent source database DML or DDL transactions (in committed order).
Attaches to a background process in the target database known as a database inbound server by means of a lightweight streaming interface.
Transmits the LCRs to the inbound server, which applies the data to the target database.
Do not use INTEGRATED
with the SPECIALRUN
or EXTFILE
options. INTEGRATED
must be used for an online change-synchronization Replicat that reads from a local EXTTRAIL
-specified trail.
Integrated Replicat does not require a checkpoint table (ADD CHECKPOINTTABLE
command and CHECKPOINTTABLE
parameter) or a trace table (TRACETABLE
parameter). Integrated Replicat does not maintain either of these tables.
When in integrated mode, Replicat does not support the following parameters:
BULKLOAD
(Do not use integrated Replicat as an initial-load Replicat.)
SPECIALRUN
GENLOADFILES
SHOWSYNTAX
MAXTRANSOPS
(is ignored)
See Installing and Configuring Oracle GoldenGate for Oracle Database for more information about configuring and using integrated Replicat.
COORDINATED [MAXTHREADS
number
]
Creates the Replicat in coordinated mode. A coordinated Replicat is multithreaded to enable parallel processing. This option adds the coordinator (identified by the group name itself) and the maximum number of processing threads that are specified by default or with MAXTHREADS
. Dependencies are computed and coordinated by the coordinator, and the SQL processing is performed by the threads.
Do not use COORDINATED
with the SPECIALRUN
or EXTFILE
options. COORDINATED
must be used for an online change-synchronization Replicat that reads from a local EXTTRAIL
-specified trail. For more information about coordinated Replicat, see Administering Oracle GoldenGate for Windows and UNIX.
Note:
Note that the group name of a coordinated Replicat can contain only five characters. See Administering Oracle GoldenGate for Windows and UNIX for more information about naming conventions for process groups.
MAXTHREADS
number
Specifies the maximum number of processing threads that this Replicat group can spawn. These threads are all created on startup, but depending on what is specified in the MAP
statements in the parameter file, some or all of these threads will process the workload at any given time. As a general rule, specify twice the number of threads that you specify in the MAP
statements when you partition the workload. This allows you to add threads in the event that the workload increases, without having to drop and recreate the Replicat group.
See TABLE | MAPfor more information about how to partition the workload across threads.
The default number of threads is 25 if MAXTHREADS
is omitted. The maximum number of threads is 500.
MAXTHREADS
has a relationship to the MAXGROUPS
parameter. MAXGROUPS
controls the maximum number of process groups (Extract and Replicat) allowed per instance of Oracle GoldenGate. Each Replicat thread is considered a Replicat group in the context of MAXGROUPS
. Therefore, the number of Extract and Replicat groups in the Oracle GoldenGate instance, plus the value of MAXTHREADS
, cannot exceed the value of MAXGROUPS
. For more information, see MAXGROUPS.
SPECIALRUN
Creates a Replicat special run as a task. Either SPECIALRUN
, EXTFILE
, or EXTTRAIL
is required. When Extract is in SPECIALRUN
mode, do not start Replicat with the START REPLICAT
command in GGSCI. Do not use this option with the INTEGRATED
or COORDINATED
option.
EXTFILE
file_name
Specifies the relative or fully qualified name of an extract file that is specified with RMTFILE
in the Extract parameter file. Do not use this option with the INTEGRATED
option.
EXTTRAIL
trail_name
Specifies the relative or fully qualified name of a trail that was created with the ADD RMTTRAIL
or ADD EXTTRAIL
command.
BEGIN {NOW |
yyyy-mm-dd[ hh:mm
[
:
ss
[.
cccccc
]]]}
Defines an initial checkpoint in the trail. See Administering Oracle GoldenGate for Windows and UNIX for more information about checkpoints.
EXTSEQNO
sequence_number
Specifies the sequence number of the file in a trail in which to begin processing data. Specify the sequence number, but not any zeroes used for padding. For example, if the trail file is c:\ggs\dirdat\aa000026
, you would specify EXTSEQNO 26
.
By default, processing begins at the beginning of a trail unless this option is used. To use EXTSEQNO
, you must also use EXTRBA
. Contact Oracle Support before using this option.
EXTRBA
rba
Specifies the relative byte address within the trail file that is specified by EXTSEQNO
. Contact Oracle Support before using this option.
CHECKPOINTTABLE
owner.table
Not valid for Oracle GoldenGate Applications Adapter or Oracle GoldenGate Big Data.
Specifies that this Replicat group will write checkpoints to the specified table in the database. Include the owner and table name, as in hr.hr_checkpoint.
This argument overrides any default CHECKPOINTTABLE
specification in the GLOBALS
file. The table must first be added with the ADD CHECKPOINTTABLE
command. Do not use this option with the INTEGRATED
option. When NODBCHECKPOINT
is specified, an additional checkpoint file for Java is not created.
NODBCHECKPOINT
Specifies that this Replicat group will not write checkpoints to a checkpoint table. This argument overrides any default CHECKPOINTTABLE
specification in the GLOBALS
file. This argument is required if you do not want to use a checkpoint table with the Replicat group that is being created. Do not use this option with the INTEGRATED
option.
PARAMS
file_name
Specifies a parameter file in a location other than the default of dirprm
within the Oracle GoldenGate directory. Specify the fully qualified path name.
REPORT
file_name
Specifies the full path name of a process report file in a location other than the default of dirrpt
within the Oracle GoldenGate directory.
DESC '
description
'Specifies a description of the group, such as 'Loads account_tab on Serv2
'. Enclose the description within quotes. You can use either the abbreviated keyword DESC
or the full word DESCRIPTION
.
CPU
number
Valid for SQL/MX. Specifies the number of the CPU to be used for the process. Valid values are numbers 0
- 15
and -1
is default, which is assigned 1 higher than the last Manager started.
PRI
number
Valid for SQL/MX. Specifies the Extract process priority. Valid values are numbers are 1
- 199
and -1
is the default, and is the same as the manager process priority.
HOMETERM
device_name
Valid for SQL/MX. Specifies the name of the device to be used and must be a terminal or process. It can be entered in either Guardian $
or OSS /G/
xxxxx
form. The default is $zhome
or the current session HOMETERM
when $zhome
is not defined.
PROCESSNAME
process_name
Valid for SQL/MX. Specifies the name of the process as alphanumeric string up to five characters and can be entered in either Guardian $
or OSS /G/
xxxxx
form. The default is a system generated process name.
Examples
ADD REPLICAT sales, EXTTRAIL dirdat/rt
ADD REPLICAT sales, INTEGRATED, EXTTRAIL dirdat/rt
This example creates Replicat in coordinated mode. It indicates that up to 100 threads can be employed in parallel at any given point in processing.
ADD REPLICAT sales, COORDINATED MAXTHREADS 100, EXTTRAIL dirdat/rt
This example creates Replicat on a SQL/MX platform.
ADD REPLICAT reptcp, CPU 2, PRI 148, HOMETERM $ZTN0.#PTHBP32, PROCESSNAME $rep1