Capture Creation – Using add_global_rules procedure

At the destination database, the instantiation SCN is set for the entire database and all of the database objects by using the set_global_instantiation_scn of the package dbms_apply_adm procedure.

At the source database, a propagation can be created that propagates all changes from the source queue by using the add_global_propagation_rules procedure.  By using the add_global_rules procedure, the Apply process can be configured at the destination database.

So far, quite a lot ground has been covered on Capture process creation, capture management, etc. In the next section, the configuration of Propagation will be presented as well as how it is managed.

Propagation Process

Once the changes to the database tables are captured, they are staged to the specified queue of type SYS.AnyData. Only the changes which qualify after the rule engine evaluation process make their way into the staging queue in the form of LCRs for further propagation.

The main objective of the Propagation process is to send the enqueued message to the destination queue from the source queue. A propagation is always between the source queue and the destination queue. However, a single queue may participate in many propagations.