xstream_oldest_acceptable_build_timeout_hours

The default is one hour. This value means that when CDC Replication decides that a capture initialization point might be needed, it skips creating one if CDC Replication detects an existing archived file that could serve as an initialization point within one hour of the check time. As a result of this choice, a capture could be initialized with a first_scn that is older than the current time, and latency should be expected until capture processes all of the data up to the position where data needs to be distributed to the target datastore.

Capture initialization points are triggered by invoking the DBMS_CAPTURE_ADM.BUILD Oracle stored procedure. Review the Oracle documentation to understand the effects of creating a capture initialization point for your database.

Applies to

Source datastores

Possible special values

0

This special value almost entirely stops CDC Replication from taking initialization points. It would rely on initialization points that are taken by the command line utility dmbuilddatadict, which must be scheduled by the end user. CDC Replication fails to create a capture if it cannot find an initialization point to initialize a capture from. Review the Oracle documentation to better understand Oracle XStream capture requirements.

-1

A special value that triggers taking new capture initialization points any time that CDC Replication considers that a capture initialization might be needed in the future.