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_name
The 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_name
The name of the Extract group to which the trail is bound. Only one primary Extract process can write data to a remote trail.
MEGABYTES
n
The maximum size, in megabytes, of a file in the trail. The default is 500.
SEQNO
n
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 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.