Oracle GoldenGate Parallel Replication Internals.pdf
5墨值下载
Oracle GoldenGate Parallel
Replication Internals
Adam Leszczyński
POUG 2018, Sopot
07.09.2018
2
07.09.2018 POUG 2018, Sopot: “Oracle GoldenGate Parallel Replication Internals”, © 2018 by Adam Leszczyński, all rights reserved
Questions for today
●
How does OGG makes sure that:
–
There are no duplicate transactions?
–
None of the transactions are missed?
–
… event in case of hardware failure?
–
… how is this data managed when the replication uses parallel processing?
–
Is this technical data available to the user?
●
What is the order of the transactions that are replicated using Parallel Replication?
–
Can this order be changed? What drives it?
–
What about transaction dependencies?
–
Is the order of COMMIT operations always preserved in the target database?
–
How different Replicat options affect the order of replicated transactions?
●
What does mean: eager apply, serialized, dependent, dependent eager, commit serialization and how do all
apply options for Replicat influence the behavior or parallel replication?
3
07.09.2018 POUG 2018, Sopot: “Oracle GoldenGate Parallel Replication Internals”, © 2018 by Adam Leszczyński, all rights reserved
Disclaimer
●
Don’t believe a single word you see here – Check everything by yourself!
●
Always first read the documentation and MOS docs
●
Results presented in this presentation are based on own research done
using the following software versions:
–
Database: 12.1 + PSU 12.1.0.2.180717, 12.2 + RU 12.2.0.1.180717
–
OGG: 12.2.0.2.2, 12.3.0.1.4
●
Important note: This presentation contains some simplifications for
educational purposes
●
Do not make any business decisions based on this presentation!
of 39
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论