Support for Oracle sequence replication is supported for replication to Oracle only. No support is provided for replicating a sequence value to a non-Oracle standby database.
Mirror Replication Agent supports replication of sequences in the primary database. To replicate a sequence invoked in a primary database, the sequence must be marked for replication, and replication must be enabled 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, see “Enabling and disabling replication for sequences”.
Oracle does not log information every time a sequence is incremented. Sequence replication occurs when Mirror Replication Agent captures the system table updates that occur when the sequence 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 that 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.
If you need to temporarily suspend replication of a marked sequence, you can disable replication for the sequence.
