oracle stream可以同步sequence的创建和变更, 但不会同步sequence值的变化,如a_seq.nextval在备份库是不会执行的, 因为stream同步的是dml的内容
如何解决sequence的主备上不一致呢?
1,主备机上定义sequence时,永远不会重叠
1st : start with 1 increment by 2
2nd: start with 2 increment by 2
2,独立区间
1st : start with 1 increment by 2 end with 10000
2nd: start with 10001 increment by 2
如何解决sequence的主备上不一致呢?
1,主备机上定义sequence时,永远不会重叠
1st : start with 1 increment by 2
2nd: start with 2 increment by 2
2,独立区间
1st : start with 1 increment by 2 end with 10000
2nd: start with 10001 increment by 2
259
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
