Oracle
There are multiple ways to identify Replicat transaction in an Oracle environment. When Replicat is in classic or integrated mode, you use the following parameters:
-
Replicats set a tag of 00 by default. Use
DBOPTIONS
with theSETTAG
option in the Replicat parameter file to change the tag that Replicat sets. Replicat tags the transactions being applied with the specified value, which identifies those transactions in the redo stream. Valid values are a single TAG value consisting of hexadecimal digits.
-
Use the
TRANLOGOPTIONS
parameter with theEXCLUDETAG
option in the Extract parameter file. The logmining server associated with that Extract excludes redo that is tagged with theSETTAG
value.The following shows how
SETTAG
can be set in the Replicat parameter file:DBOPTIONS SETTAG 0935
The following shows how
EXCLUDETAG
can be set in the Extract parameter file:TRANLOGOPTIONS EXCLUDETAG 0935
If you are excluding multiple tags, each must have a separate
TRANLOGOPTIONS EXCLUDETAG
statement specified.
You can also use the transaction name or userid of the Replicat user to identify Replicat transactions. You can choose which of these to ignore when you configure Extract. See Preventing the Capture of Replicat Transactions (Oracle).
For more information, see Parameters and Functions Reference for Oracle GoldenGate.