ADD RMTTRAIL
Use ADD RMTTRAIL to create a trail for online
processing by a Replicat on a remote, target system. The command:
-
Assigns a maximum file size.
-
Associates the trail with an Extract group.
-
Uses remote trails in a Pump Extract.
Syntax
ADD RMTTRAIL trail_name, EXTRACT group_name
[, FORMAT RELEASE major.minor]
[, MEGABYTES n]
[, SEQNO n]-
trail_name -
(For Classic Architecture), The relative or fully qualified path name of the remote trail, including a two character (alpha-numeric) maximum trail name. For example:
dirdat/ea.For Microservices Architecture, a two character (alpha-numeric) maximum trail name, with no path listed, and the first character must not be a number. For example
ea.Oracle GoldenGate appends this name with a nine-digit sequence number whenever a new file is created. For example, a trail named
eawould have trail files namedea000000000,ea000000001.Note:
Note: The trail file name and path (for Classic Architecture) must exactly match the
RMTTRAILparameter used in the Extract. -
group_name -
The name of the Extract group to which the trail is bound. A remote trail can only be assigned to one Extract. Multiple Extracts cannot write to the same trail. However, one Extract can write to multiple distinct remote trails.
-
MEGABYTESn -
The maximum size, in megabytes, of a file in the trail. The default is 500, however, the value can be between 1 MB and 2000 MB (maximum).
-
SEQNOn -
Specifies that the first file in the trail will start with the specified trail sequence number. Do not include any zero padding. For example, to start at sequence 3 of a trail named
ea, specifySEQNO 3. The actual file would be namedea000000003. This option can be used during troubleshooting when Replicat needs to be repositioned to a certain trail sequence number. It eliminates the need to alter Replicat to read the required sequence number.