The parameter SP_OPO_DISABLE_OBJECT_NUM be configured to have Post ignore replication of sequence(s). As far as sequences are concerned, Shareplex only replicates a series of DDLs once the current value referenced by sequence exceeds the LAST_NUMBER value for that sequence, which also happens to be the value of CACHE for that sequence. So, essentially it is only ignoring the DDLs for that sequence. This cycle of DDL replication to target sequence repeats every time the increments to the sequence exceed the CACHE.
To have Post ignore the DDL for a sequence in replication (since DML for sequences are not replicated), set the following parameter on target sp_ctrl:
sp_ctrl>set param SP_OPO_DISABLE_OBJECT_NUM <object_id of sequence from source database)
sp_ctrl>stop post [queue <queue_name>]
sp_ctrl>start post [queue <queue_name>]
Here is the description of the parameter as taken from SharePlex Reference Guide:
SP_OPO_DISABLE_OBJECT_NUM
This parameter prevents Post from posting replicated DML and DDL operations to the target, based on
the object ID of the source table. You can set this parameter if the data in a source table is
invalid or corrupted, if the source table contains datatypes that are not supported on the target, or for any other reason that you do not want operations for a table to be reflected in the target database.
You can set this parameter for one or more tables. It prevents further replication activity on the
target table(s) of a source table until you have time to resynchronize the data and reactivate the
configuration file. The Post process discards all replicated messages for these tables from the
post queue, and the messages do not accumulate in the queue.
Use the parameter with caution. If it is enabled and DDL or DML is executed for the source
table(s), the target data will be out of date because the changes are not posted. If there are
dependencies on the table(s), such as a foreign key in other tables outside the replication
configuration, disabling posting will prevent the dependencies from being satisfied.
This parameter is disabled by default. To enable it, issue the following command on the target
system, where the numbers shown are the object IDs of the source tables to exclude from posting.
sp_ctrl(sysB)> set param SP_OPO_DISABLE_OBJECT_NUM object 12345,67890
Separate each object ID with a comma, and allow no spaces between them. To use spaces between
entries, enclose the entire list within quotes, as in the following example:
sp_ctrl(sysB)> set param SP_OPO_DISABLE_OBJECT_NUM "498438, 1000, 497109") Invalid object IDs will be ignored.
When you are ready to begin posting to the target table again, reset SP_OPO_DISABLE_OBJECT_NUM so that it will assume the default value of NULL.
Default: NULL (off)
Range of valid values: list of valid Oracle Object IDs separated by commas
Takes effect: when Post is restarted
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center