LogXptMode

The LogXptMode configurable property enables you to set the redo transport service.

You set the redo transport services on each configuration member to one of the following modes:

  • SYNC

    Configures redo transport services for this configuration member using the SYNC and AFFIRM attributes of the LOG_ARCHIVE_DEST_n initialization parameter. Standby redo log files are required. This mode is required for the maximum protection or maximum availability data protection modes. This redo transport service enables the highest grade of data protection to the primary database, but also incurs the highest performance impact.

  • ASYNC

    Configures redo transport services for this configuration member using the ASYNC and NOAFFIRM attributes of the LOG_ARCHIVE_DEST_n initialization parameter. Standby redo log files are required. This mode enables a moderate grade of data protection to the primary database, and incurs a lower performance impact than SYNC.

  • FASTSYNC

    Configures redo transport services for this configuration member using the SYNC and NOAFFIRM attributes of the LOG_ARCHIVE_DEST_n initialization parameter. This mode is only available in maximum availability protection mode. Because FASTSYNC transport mode uses the NOAFFIRM attribute of the LOG_ARCHIVE_DEST_n parameter, data loss is possible.

Category Description

Datatype

String

Valid values

SYNC, ASYNC, or FASTSYNC

Broker default

ASYNC

Imported?

No

Parameter class

Dynamic

Role

Standby database, Recovery Appliance, far sync instanceFoot 1

Standby type

Physical, logical, or snapshot standby, far sync instance, Recovery Appliance

Corresponds to

  • SYNC, ASYNC, AFFIRM, and NOAFFIRM attributes for the LOG_ARCHIVE_DEST_n initialization parameter of the database or far sync instance that is sending redo data

  • ARCHIVER, TRANSMIT_MODE, and AFFIRM columns of V$ARCHIVE_DEST view of the database or far sync instance that is sendng redo data

Scope

Database, far sync instance, Recovery Appliance

Cloud Control name

Redo Transport Service

Footnote 1

Although this property is set for the standby database or far sync instance, it is indirectly related to the redo transport services for the database or far sync instance that is sending redo. The broker propagates the setting you specify on the standby database or far sync instance to the corresponding attributes of the LOG_ARCHIVE_DEST_n value of the database or far sync instance that is sending redo data. Note that if a database receives redo from a database or far sync instance where the RedoRoutes property has been configured with a redo transport mode, then the mode specified by that RedoRoutes property value overrides the value of the LogXptMode property.

See Also:

Managing the Members of a Broker Configuration for more information about setting data protection modes for redo transport services