When replicating sequences, you notice that target sequences are smaller than what's on source
1. Post queue was reset
2. Messages were removed from the post queue
To Resync sequences that are OUT of Sync on the TARGET steps are detailed below:
1. remove sequences from the active config on Source.
2. make sure you are not replicating DDL from Source to Target.
3. recreate sequences on target from the source.
NOTE:SharePlex replicates changes to sequences that are made during transactions and with
the ALTER SEQUENCE command.To ensure the uniqueness of sequences on the target system, the start value of the target
sequence must be larger than the start value of the source sequence. Use the following
formula to determine the target START_WITH value:
source current value + [{SOURCE_INCREMENT_BY_VALUE.EN} x {SOURCE_CACHE_VALUE.EN}] =
target START_WITH_value
4. activate original config on source.
5. The first time 'select seq_name.nextval from dual' is done on source after activation, shareplex will update the target sequence and increase it by the cache size. This will ensure target sequence is always higher than source by at least the cache size for failover purposes. If you have reverse activation on target, please keep in mind shareplex will do the exact same thing just in the opposite way if you do a 'select seq_name.nextval from dual' on target. Such select command should only be issued on target upon application fail over.
For more information regarding sequence replication, refer to shareplex admin guide chapter 3.
