Use ADD RMTTRAIL to create a trail for online processing on a remote system and:
Assign a maximum file size.
Associate the trail with an Extract group.
In the parameter file, specify a RMTHOST entry before any RMTTRAIL entries to identify the remote system and TCP/IP port for the Manager process.
Note:
The RMTTRAIL size (Target Trail) must be greater than or equal to (<=) the EXTTRAIL size (Source Trail), due to trail encryption requirements.
Syntax
ADD RMTTRAIL trail_name, EXTRACT group_name [, MEGABYTES n] [, SEQNO n]
trail_nameThe relative or fully qualified path name of the trail. The actual trail name can contain only two characters. Oracle GoldenGate appends this name with a nine-digit sequence number whenever a new file is created. For example, a trail named ./dirdat/tr would have files named ./dirdat/tr000000001, ./dirdat/tr000000002, and so forth.
group_nameThe name of the Extract group to which the trail is bound. Only one primary Extract process can write data to a remote trail.
MEGABYTES nThe maximum size, in megabytes, of a file in the trail. The default is 500.
SEQNO nSpecifies 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 tr, specify SEQNO 3. The actual file would be named /ggs/dirdat/tr000000003. 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.