Replicating sequences in a centralized replication environment.
The best practice is to replicate sequences in a HA environment only. It may not be suitable for other replication topologies. In case of centralized replication environment, if the same object is replicated from the source nodes to the centralized target, then each source needs to have its own sequence generator and that needs to generate key values that do not conflict (or clash) with sequences generated on other nodes. For example, in case of two nodes replicating to the target, each of these two nodes can generate sequence values in odd and even series respectively, that is, one node can generate 1, 3, 5, 7, …., etc, and the other node can generate 2, 4, 6, 8, …., etc. Likewise other series can be devised if having more than 2 nodes replicating to the centralized target. The sequences themselves need not be replicated.
