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 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 ea would have trail files named ea000000000, ea000000001.

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.

MEGABYTES n

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).

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 ea, specify SEQNO 3. The actual file would be named ea000000003. 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.

Example

Admin Client

ADD RMTTRAIL north/ea, EXTRACT exte, MEGABYTES 200