Goldengate Microservices sequences.sql

cptkirksh

I know in classic GG you had to run the sequence.sql script to deal with sequences that are used as primary keys for tables. Do you need to do the same thing in MA? If not how do you deal with that? Thanks

ORASCN

Hi ,

Either it is Classic or Microservices, it is all same. Only the architecture differs, but the working is all same. So, you need to run the sequences script.

Regards,

Veera

cptkirksh

Thanks for the answer. so maybe you can help me with this. After I run all of that if I have the extract and replicat working. Then on the source I run nextval to bump the sequence up by one. Then I go check the target the sequence is now increased by 21. The cache is set to 20 on source and target. Is that due to the cache size? How do I get around that?

Gururaj0-Oracle

Please refer the following for sequence calculation.

https://docs.oracle.com/en/middleware/goldengate/core/19.1/reference/sequence.html#GUID-72E26342-D840-4725-A345-0121E9E5E805

Regards

Gururaj

ORASCN

Hello,

Check the below links to know more about sequences replication in detail,

https://jinyuwang.weebly.com/for-oracle-db/handling-sequences-in-oracle-goldengate-replications

http://www.juliandyke.com/Research/GoldenGate/GoldenGateSequences.php

Regards,

Veera