OGG Bidirectional Sequence value replication
Has anyone done Sequence value replication in Bi-Directional replication process instead of Splitting the Value and Even/Odd values.
Both my Seq is incremented by 1 and has same cache value. I have even ran @sequence.sql But I'm getting "ERROR OGG-00423 Could not find definition for SCH.SEQ1."
Current Config
------------------------------------------------------------------------------------------------------------------
Say @Source - DB1 - SEQ1 currval is 512 after a transaction (nextval)
But @ Target - DB2 - SEQ1 currval is 511 after a transaction (reading from the trail)
How do I get it to increment?