Risk-Controlled Near-Zero-Downtime Oracle Database Migration Using GoldenGate
DOI:
https://doi.org/10.22399/ijcesen.5382Keywords:
Oracle GoldenGate, zero downtime migration, Exadata, Exadata Cloud@Customer, Data Pump, cutover readinessAbstract
Large Oracle database migration is not only a data-movement activity; it is a production-risk decision that must preserve availability, correctness, recoverability, and audit evidence. Enterprise Oracle estates may include 30 TB, 50 TB, 150 TB, and 170 TB databases, with modernization paths from on-premises infrastructure to Oracle Exadata and Oracle Exadata Cloud@Customer (ExaCC). Oracle GoldenGate, used with Data Pump and validation controls, supports near-zero-downtime logical migration by capturing and applying source changes while an initial load is moved to the target. However, the central operational weakness is not replication configuration; it is cutover justification. A lag-only rule can approve cutover while trail backlog is growing, Replicat apply is constrained by target I/O, validation drift remains unresolved, checkpoint exposure is high, or rollback readiness is weak. This paper proposes the GoldenGate Migration Readiness Score (GMRS), a multi-signal framework that converts freshness, correctness, and recoverability evidence into a 0-100 risk score. A representative 2018-2021 evaluation across sanitized 30 TB to 170 TB scenarios shows that GMRS agrees with lag-only monitoring in healthy conditions but blocks or stops unsafe cutovers when backlog, validation, abend recovery, or rollback risk is present. The contribution is an auditable cutover-readiness framework for large Oracle estates, not another GoldenGate configuration tutorial.
References
[1] Oracle, “Oracle GoldenGate 19c Documentation Library,” Oracle Documentation, 2019. DOI: N/A; URL: https://docs.oracle.com/en/middleware/goldengate/core/19.1/
[2] Oracle, “Using Oracle GoldenGate for Oracle Database, Release 19c,” Oracle Documentation, 2019. DOI: N/A; URL: https://docs.oracle.com/en/middleware/goldengate/core/19.1/oracle-db/
[3] Oracle, “Oracle Database Utilities: Data Pump Export and Import, Release 19c,” Oracle Documentation, 2019. DOI: N/A; URL: https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/
[4] Oracle, “Oracle Database High Availability Overview, Release 19c,” Oracle Documentation, 2019. DOI: N/A; URL: https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/
[5] Oracle, “Oracle GoldenGate Veridata Administrator’s Guide, Release 12.2.1,” Oracle Documentation, 2016. DOI: N/A; URL: https://docs.oracle.com/middleware/1221/ogg/veridata.htm
[6] Oracle, “Zero Downtime Migration Logical Online Migration,” Oracle Documentation, 2021. DOI: N/A; URL: https://docs.oracle.com/en/database/oracle/zero-downtime-migration/
[7] E. A. Brewer, “Towards robust distributed systems,” Proceedings of PODC, 2000. DOI: https://doi.org/10.1145/343477.343502 DOI: https://doi.org/10.1145/343477.343502
[8] S. Gilbert and N. Lynch, “Brewer’s conjecture and the feasibility of consistent, available, partition-tolerant web services,” ACM SIGACT News, 2002. DOI: https://doi.org/10.1145/564585.564601 DOI: https://doi.org/10.1145/564585.564601
[9] W. Vogels, “Eventually consistent,” Communications of the ACM, 2009. DOI: https://doi.org/10.1145/1435417.1435432 DOI: https://doi.org/10.1145/1435417.1435432
[10] J. Dean and L. A. Barroso, “The tail at scale,” Communications of the ACM, 2013. DOI: https://doi.org/10.1145/2408776.2408794 DOI: https://doi.org/10.1145/2408776.2408794
[11] M. Stonebraker et al., “The end of an architectural era,” Proceedings of VLDB, 2007. DOI: https://doi.org/10.1145/1325851.1325855
[12] P. Bailis and A. Ghodsi, “Eventual consistency today: limitations, extensions, and beyond,” Communications of the ACM, 2013. DOI: https://doi.org/10.1145/2447976.2447992 DOI: https://doi.org/10.1145/2447976.2447992
[13] A. Andreakis and I. Papapanagiotou, “DBLog: A Watermark Based Change-Data-Capture Framework,” arXiv, 2020. DOI: https://doi.org/10.48550/arXiv.2010.12597
[14] NIST, “Contingency Planning Guide for Federal Information Systems,” NIST SP 800-34 Rev. 1, 2010. DOI: https://doi.org/10.6028/NIST.SP.800-34r1 DOI: https://doi.org/10.6028/NIST.SP.800-34r1
[15] NIST, “Security and Privacy Controls for Federal Information Systems and Organizations,” NIST SP 800-53 Rev. 4, 2013. DOI: https://doi.org/10.6028/NIST.SP.800-53r4 DOI: https://doi.org/10.6028/NIST.SP.800-53r4
[16] NIST, “Risk Management Framework for Information Systems and Organizations,” NIST SP 800-37 Rev. 2, 2018. DOI: https://doi.org/10.6028/NIST.SP.800-37r2 DOI: https://doi.org/10.6028/NIST.SP.800-37r2
[17] M. Kleppmann, Designing Data-Intensive Applications. O’Reilly Media, 2017. DOI: N/A; URL: https://www.oreilly.com/library/view/designing-data-intensive-applications/9781491903063/
[18] P. A. Bernstein, V. Hadzilacos and N. Goodman, Concurrency Control and Recovery in Database Systems. Addison-Wesley, 1987. DOI: N/A; URL: https://www.microsoft.com/en-us/research/publication/concurrency-control-and-recovery-in-database-systems/
[19] J. Gray and A. Reuter, Transaction Processing: Concepts and Techniques. Morgan Kaufmann, 1993. DOI: N/A; ISBN: 978-1-55860-190-1
[20] B. Beyer et al., Site Reliability Engineering. O’Reilly Media, 2016. DOI: N/A; URL: https://sre.google/sre-book/table-of-contents/
[21] B. Beyer et al., The Site Reliability Workbook. O’Reilly Media, 2018. DOI: N/A; URL: https://sre.google/workbook/table-of-contents/
[22] N. R. Herbst, S. Kounev and R. Reussner, “Elasticity in cloud computing: what it is, and what it is not,” ICAC, 2013. DOI: https://doi.org/10.1109/ICAC.2013.21
[23] C. Fehling et al., Cloud Computing Patterns. Springer, 2014. DOI: https://doi.org/10.1007/978-3-7091-1568-8 DOI: https://doi.org/10.1007/978-3-7091-1568-8
[24] A. Fox et al., “Above the Clouds: A Berkeley View of Cloud Computing,” UC Berkeley Technical Report, 2009. DOI: N/A; URL: https://www2.eecs.berkeley.edu/Pubs/TechRpts/2009/EECS-2009-28.html
[25] I. Rae, E. Rollins, J. Shute, S. Sodhi and R. Vingralek, “Online, Asynchronous Schema Change in F1,” Proceedings of the VLDB Endowment, vol. 6, no. 11, 2013. DOI: https://doi.org/10.14778/2536222.2536230 DOI: https://doi.org/10.14778/2536222.2536230
[26] NIST, “Guide for Conducting Risk Assessments,” NIST SP 800-30 Rev. 1, 2012. DOI: https://doi.org/10.6028/NIST.SP.800-30r1 DOI: https://doi.org/10.6028/NIST.SP.800-30r1
[27] Oracle, “Oracle GoldenGate Microservices Architecture,” Oracle White Paper, 2019. DOI: N/A; URL: https://www.oracle.com/middleware/technologies/goldengate.html
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2022 International Journal of Computational and Experimental Science and Engineering
This work is licensed under a Creative Commons Attribution 4.0 International License.
