Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

High values when replicating sequences in active-active

TheLonelyDBANov 29 2018 — edited Dec 11 2018

Hi,

Im trying out a active-active replication using GG 12.3 on Linux. I have managed to replicat my sequences from A->B and B->A. But the values suddenly increases alot, this is my own schema so not other activity in it, it can look like this:

SUPPLIER_ID SUPPLIER_NAME        CONTACT_NAME

          1 TEST                 USER1

           ...

          9 TEST                 USER1

         11 TEST                 USER1

       1243 TEST                 USER1

       1245 TEST                 USER1

       1247 TEST                 USER1

       3077 TEST                 USER1

       3079 TEST                 USER1

       3081 TEST                 USER1

       3120 TEST                 USER1

       3122 TEST                 USER1

       3124 TEST                 USER1

As you can see, the sequence suddenly increases its nextval without any data being written, any ideas?

Regards

TheLonelyDBA

This post has been answered by NeilChandler on Nov 29 2018
Jump to Answer
Comments
Post Details
Added on Nov 29 2018
1 comment
275 views