Mirror Replication Agent supports replication of sequences in the primary database. In order to replicate a sequence invoked in a primary database, the sequence must be marked for replication and replication must beanball for that sequence. (This is analogous to marking and enabling replication for tables.)
Marking a sequence for replication is separate from
enabling replication for the sequence. If the value of the pdb_dflt_object_repl
parameter is true, replication is enabled automatically at the time
a sequence is marked. For more information on enabling and disabling
replication for a marked sequence, see “Enabling and disabling
replication for “Enabling and disabling replication for sequences”.
Oracle does not log information every time a sequence is incremented. Sequence replication occurs when the Mirror Replication Agent captures the system table updates that occur when the sequence's cache is refreshed. Therefore, the sequence value replicated when a sequence is marked for replication is the 'next' sequence value to be used when the current cache expires. The result is not every individual increment of a sequence is replicated, but the standby site will always have a value greater than the primary site's currently available cached values. For more information on Sequence replication, see Appendix C, Mirror Replication Agent and Oracle Databases.
If you need to temporarily suspend replication of a marked sequence you can disable replication for the sequence. For more information see "Enabling and disabling replication for “Marking and unmarking sequences”.
