11 Creating Process Groups
Topics:
- Prerequisites
This chapter assumes you have installed Oracle GoldenGate, understand the different processing options available to you, and have performed the following prerequisite configuration steps before proceeding to configure Oracle GoldenGate process groups. - Registering Extract with the Mining Database
If you are using Extract in integrated mode, you need to create a database logmining server to capture redo data. You do this from the GGSCI interface by registering the primary Extract process with the mining database. - Add the Primary Extract
The primary Extract writes to a trail. - Add the Local Trail
These steps add the local trail to which the primary Extract writes captured data. - Add the Data Pump Extract Group
These steps add the data pump that reads the local trail and sends the data to the target. - Add the Remote Trail
Although it is read by Replicat, this trail must be associated with the data pump, so it must be added on the source system, not the target. - Add the Replicat Group
These steps add the Replicat group that reads the remote trail and applies the data changes to the target Oracle Database.
Prerequisites
This chapter assumes you have installed Oracle GoldenGate, understand the different processing options available to you, and have performed the following prerequisite configuration steps before proceeding to configure Oracle GoldenGate process groups.
Parent topic: Creating Process Groups
Registering Extract with the Mining Database
If you are using Extract in integrated mode, you need to create a database logmining server to capture redo data. You do this from the GGSCI interface by registering the primary Extract process with the mining database.
The creation of the logmining server extracts a snapshot of the source database in the redo stream of the source database. In a source multitenant container database, you register Extract with each of the pluggable databases that you want to include for capture.
WARNING:
Make certain that you know the earliest SCN of the log stream at which you want Extract to begin processing. Extract cannot have a starting SCN value that is lower than the first SCN that is specified when the underlying database capture process is created with the REGISTER EXTRACT
command. You can use the SCN
option
Note:
The register process may take a few to several minutes to complete, even though the REGISTER
command returns immediately.
Parent topic: Creating Process Groups
Add the Primary Extract
The primary Extract writes to a trail.
These steps add the primary Extract that captures change data.
Example 11-1 Classic capture with timestamp start point
ADD EXTRACT finance, TRANLOG, BEGIN 2011-01-01 12:00:00.000000
Example 11-2 Integrated capture with timestamp start point
DBLOGIN USERIDALIAS myalias ADD EXTRACT finance, INTEGRATED TRANLOG, BEGIN NOW
Parent topic: Creating Process Groups
Add the Local Trail
These steps add the local trail to which the primary Extract writes captured data.
In GGSCI on the source system, issue the ADD EXTTRAIL
command:
ADD EXTTRAILpathname
, EXTRACTgroup name
Where:
-
EXTTRAIL
specifies that the trail is to be created on the local system. -
pathname
is the relative or fully qualified name of the trail, including the two-character name. -
EXTRACT
group name
is the name of the primary Extract group.
Note:
Oracle GoldenGate creates this trail automatically during processing.
Example 11-3
ADD EXTTRAIL /ggs/dirdat/lt, EXTRACT finance
Parent topic: Creating Process Groups
Add the Data Pump Extract Group
These steps add the data pump that reads the local trail and sends the data to the target.
In GGSCI on the source system, issue the ADD EXTRACT
command.
ADD EXTRACTgroup name,
EXTTRAILSOURCEtrail name
Where:
-
group name is the name of the Extract group.
-
EXTTRAILSOURCE
trail name
is the relative or fully qualified name of the local trail.
Example 11-4
ADD EXTRACT financep, EXTTRAILSOURCE c:\ggs\dirdat\lt
Parent topic: Creating Process Groups
Add the Remote Trail
Although it is read by Replicat, this trail must be associated with the data pump, so it must be added on the source system, not the target.
These steps add the remote trail:
In GGSCI on the source system, issue the following command:
ADD RMTTRAIL
pathname,
EXTRACT
group name
Where:
-
RMTTRAIL
specifies that the trail is to be created on the target system. -
pathname is the relative or fully qualified name of the trail, including the two-character name.
-
EXTRACT
group name
is the name of the data-pump Extract group.
Note:
Oracle GoldenGate creates this trail automatically during processing.
Example 11-5
ADD RMTTRAIL /ggs/dirdat/rt, EXTRACT financep
Parent topic: Creating Process Groups
Add the Replicat Group
These steps add the Replicat group that reads the remote trail and applies the data changes to the target Oracle Database.
Example 11-6 Adds a Nonintegrated Replicat
ADD REPLICAT financer, EXTTRAIL c:\ggs\dirdat\rt
Example 11-7 Adds an Integrated Replicat
ADD REPLICAT financer, INTEGRATED, EXTTRAIL c:\ggs\dirdat\rt
Parent topic: Creating Process Groups