Consistency-Preserving Incremental Transportable Tablespaces (iTTS) for Near-Zero Downtime Autonomous Database Cutovers
DOI:
https://doi.org/10.56830/IJSIE202607Keywords:
Incremental Transportable Tablespaces (iTTS), Oracle Autonomous Database, Near-Zero Downtime, RMAN Incremental Backup, SCN-Based ConsistencyAbstract
The final outage time of Oracle Autonomous Database migration depends on the size of the database. The quantity of data changes before the outage is still a challenge when trying to achieve a near-zero outage. This study evaluated the effectiveness of consistency-preserving incremental Transportable Tablespaces in achieving write-unavailable time with deterministic source-to-target correctness. It is also possible to maintain source-to-target deterministic consistency correctness. A controlled experiment in a repeated-measures design was used for 45 end-to-end cutovers within 24,000,000 NYC TLC Yellow Taxi records and three different changed-block rates, two level-1 backup cadences, and non-incremental TTS baselines. The experiment was performed on an Oracle 19c database on the same endian hardware with OCI Object Storage and RMAN parallelism 8-channel8-channel. The results indicated that the median outage time using iTTS was 12.1 minutes, which was 83.9% less than the outage time of 75.2 minutes with non-incremental TTS. There were no zero transport-set violations, no missed committed keys, no duplicate primary keys, or cross-SCN probe failures for all 39 incremental cutovers. This was the one-hour cadence for obtaining a median final Delta of 1.8GB and a median cutover time of 9.7 minutes, accounting for approximately 89% of the variation in cutover time with incremental volume. The materiality of the reduction in cutover downtime using iTT was found to be independent of the techniques used to control changedblock growth and ensure reconciliation during cutover. Additional research should be conducted to further validate Adaptive Scheduling, Failure Recovery, and production-scale behavior in the future.
References
A. Ubale. (2023). “Beyond telematics: Leveraging generative AI for synthetic accident reconstruction and liability attribution in autonomous vehicle claims,”. International Journal of AI, BigData, Computational and Management Studies, vol. 4, no. 4, pp. 119–124, https://ijaibdcms.org/index.php/ijaibdcms/article/download/356/352.
B. Curtis. (2025). Pro Oracle GoldenGate 23ai for the DBA. Apress, https://link.springer.com/content/pdf/10.1007/979-8-8688-0782-4.pdf.
C. Nallapareddy. (2025). “Database cloud migration strategy for a business-critical application,” . Journal of Technology and Systems, vol. 7, no. 2, pp. 22–32, https://ideas.repec.org/a/bhx/ojtjts/v7y2025i2p22-32id2635.html.
Costigan, S., Ruscio, J., & J. T. Crawford. (2024). “Performing small-telescopes analysis by resampling: Empirically constructing confidence intervals and estimating statistical power for measures of effect size,”. Advances in Methods and Practices in Psychological Science, vol. 7, no. 1, Art. no. 25152459241227865, https://scholar.google.com/scholar?output=instlink&q=info:fhG4JcwMM6kJ:scholar.g oogle.com/.
Eckwert, T., Guckert, M., & G. Taentzer. (2025). “EvolveDB: Evolving relational database schemas in a model-driven way,”. Software and Systems Modeling, pp. 1–26, https://link.springer.com/content/pdf/10.1007/s10270-025-01341-x.pdf.
G. Malik. (2024). “Biometric authentication—Risks and advancements in biometric security systems,”. Journal of Computer Science and Technology Studies, vol. 6, no. 3, pp. 159–180. https://alkindipublisher.com/index.php/jcsts/article/download/9131/7816.
Gan, Q., Wang, X., Huang, D., Li, J., Wang, C., & Z. Liu. (2024). “Online/offline remote data auditing with strong key-exposure resilience for cloud storage,”. Computer Standards & Interfaces, vol. 88, Art. no. 103798, https://www.sciencedirect.com/science/article/pii/S092054892300079X.
Gannavarapu, P., & R. K. R. Samantapudi. (2025). “Secure AI-driven identity infrastructure for regulated sectors,”. International Journal of Intelligent Systems and Applications in Engineering, https://www.ijisae.org/index.php/IJISAE/article/view/7913.
Google Cloud. (2025). “Migrate from AWS to Google Cloud: Migrate from Amazon RDS and Amazon Aurora for MySQL to Cloud SQL for MySQL,” . Google Cloud Architecture Center, https://docs.cloud.google.com/architecture/migrate-aws-rds-tosql-mysql.
H. Cao et al. (2025). “Aion: Live migration for in-memory databases with zero downtime and reduced redundant data transfer,”. Data Science and Engineering, vol. 10, no. 2, pp. 212–229, https://link.springer.com/content/pdf/10.1007/s41019-024-00276-5.pdf.
H. Razzaghi et al. (2024). “Systematic data quality assessment of electronic health record data to evaluate study-specific fitness: Report from the PRESERVE research study,”. PLOS Digital Health, vol. 3, no. 6, Art. no. e0000527. https://journals.plos.org/digitalhealth/article/file?id=10.1371/journal.pdig.0000527&ty pe=printable.
Haris, R. M., Barhamgi, M., Nhlabatsi, A., & K. M. Khan. (2024). “Optimizing pre-copy live virtual machine migration in cloud computing using machine learning-based prediction model,”. Computing, vol. 106, no. 9, pp. 3031–3062, https://link.springer.com/content/pdf/10.1007/s00607-024-01318-6.pdf.
Hebbar, K. S., Patel, P., & S. Sepuri. (2026). “Graph-augmented AI systems for deep reasoning in enterprise codebases and regulatory documents,”. in Global Conference on Sustainable Energy Systems, Smart Electronics and Intelligent Computing (GCSESEIC 2025), pp. 708–722. Atlantis Press. https://www.atlantispress.com/article/126023432.pdf.
Henning, S., Vogel, A., Perez-Wohlfeil, E., Ertl, O., & R. Rabiser. (2025). “When should I run my application benchmark? Studying cloud performance variability for the case of stream processing applications,”. Int. Conf. Foundations of Software Engineering, pp. 400–410. https://dl.acm.org/doi/pdf/10.1145/3696630.3728563.
Hyun, G., Oak, J., Kim, D., & K. Kim. (2024). “The impact of an automation system built with Jenkins on the efficiency of container-based system deployment,” . Sensors, vol. 24, no. 18, Art. no. 6002, https://www.mdpi.com/1424-8220/24/18/6002.
Jha, A. C., Gannavarapu, P., & S. Durgam. (2025). “Machine learning-driven security system for next-generation ultra-low-latency financial network governance,” . https://ieeexplore.ieee.org/abstract/document/11374574.
Jibril, M. A., Baumstark, A., & K.-U. Sattler. (2023). “Adaptive update handling for graph HTAP,” . Distributed and Parallel Databases, vol. 41, no. 3, pp. 331–357, https://link.springer.com/content/pdf/10.1007/s10619-023-07428-y.pdf.
Kim, D., Han, J., Son, S., Gil, M. S., Moon, Y. S., & H. Won. (2024). “Demeter: An automatic framework for data migration in open data lakes,”. Software: Practice and Experience, vol. 54, no. 5, pp. 721–743, https://onlinelibrary.wiley.com/doi/pdf/10.1002%2Fspe.3294.
Kotlarska, I., Jackowski, A., Lichota, K., Welnicki, M., Dubnicki, C., & K. Iwanicki. (2023). “InftyDedup: Scalable and cost-effective cloud tiering with deduplication,”. in Proc. 21st USENIX Conf. File and Storage Technologies (FAST ’23), pp. 33–48. https://www.usenix.org/system/files/fast23-kotlarska.pdf.
Kumar, Y. R., Raghavendra, S., & A. Goel. (2024). Oracle Cloud Infrastructure (OCI) GoldenGate. Apress, https://link.springer.com/content/pdf/10.1007/979-8-8688-0303- 1.pdf .
M. Kalkatawi. (2025). “Beyond the upgrade: Unraveling the complexities of health information system migration,” . Discover Health Systems, vol. 4, no. 1, Art. no. 7, https://link.springer.com/content/pdf/10.1007/s44250-025-00186-x.pdf.
Malcher, M., & D. Kuhn. (2024). Pro Oracle Database 23c Administration: Manage and Safeguard Your Organization’s Data. Apress, p. 588. https://link.springer.com/book/10.1007/978-1-4842-9899-2.
Netinant, P., Saengsuwan, N., Rukhiran, M., & S. Pukdesree. (2023). “Enhancing data management strategies with a hybrid layering framework in assessing data validation and high availability sustainability,”. Sustainability, vol. 15, no. 20, Art. no. 15034, https://www.mdpi.com/2071-1050/15/20/15034.
Oracle. (2024). “Learn about migrating a database from on-premises to the cloud with Oracle RMAN,”. Oracle Cloud Infrastructure Architecture Center, https://docs.oracle.com/en/solutions/migrate-database-with-rman/index.html.
Oracle. (2025). “Support for transportable tablespaces,” . Oracle Cloud Infrastructure Release Notes, https://docs.oracle.com/en-us/iaas/releasenotes/autonomous-databaseserverless/2025-12-support-for-transportable-tablespaces.htm.
Oracle. (2026). “RMAN backup concepts,”. in Oracle AI Database Backup and Recovery User’s Guide, https://docs.oracle.com/en/database/oracle/oracledatabase/26/bradv/part-setting-rman-cloud-backups.html.
P. Gannavarapu. (2025). “Deploying Azure AD federation with SAML for secure enterprise SaaS integration,”. Computer Fraud & Security, https://computerfraudsecurity.com/index.php/journal/article/view/782.
P. K. R. Prakashkumar. (2025). “Analytical study of Vertex–Oracle Cloud integration in enterprise ERP systems for automated tax compliance and efficient financial closings,”. International Journal of Accounting and Management Sciences,, vol. 4, no. 4, https://scipubhouse.com/international-journal-of-accounting-and-managementsciences-ijams/content/ijams-vol-4-no-4-october-2025/analytical-study-of-vertexoracle-cloud-integration-in-enterprise-erp-systems-for-automated-tax-compliance-ande.
P. Manda. (2023). “Migrating Oracle databases to the cloud: Best practices for performance, uptime, and risk mitigation,”. International Journal of Humanities and Information Technology, vol. 5, no. 2, pp. 1–7, https://ijhit.info/index.php/ijhit/article/download/50/47.
R. Pittu. (2025). “Zero-downtime cloud migration strategies for enterprise-scale databases: Architectural patterns and implementation frameworks,”. Journal of Computer Science and Technology Studies, vol. 7, no. 7, pp. 859–865, https://alkindipublisher.com/index.php/jcsts/article/download/10396/9106.
S. K. R. Vanama. (2023). “Integrating site reliability engineering SRE principles into enterprise architecture for predictive resilience,”. International Journal of Emerging Trends in Computer Science and Information Technology, vol. 4, no. 3, pp. 164–170, https://www.ijetcsit.org/index.php/ijetcsit/article/download/514/462.
S. K. RaoVanama. (2024). “AI-augmented CI/CD pipeline optimization for scalable cloudnative deployment,”. International Journal of Artificial Intelligence, Data Science, and Machine Learning, vol. 5, no. 4, pp. 175–187, https://ijaidsml.org/index.php/ijaidsml/article/download/368/338.
S. Sepuri. (2026). “Comparative analysis of artificial intelligence test generation methods for compliance validation in regulated enterprise workflows,”. Journal of Intelligent Decision Making and Information Science, vol. 3, no. 2s, pp. 107–123, https://www.jidmis.org/index.php/jidmis/article/view/632.
S. Watanabe. (2025). “Data backup system with no impact on business processing utilizing storage and container technologies,”. in Proc. 2025 IEEE 41st Int. Conf. Data Engineering (ICDE), pp. 4568–4571. https://arxiv.org/pdf/2409.07081.
Shaik, V., & Natarajan, K. (2024). “Cloud databases: A resilient and robust framework to dissolve vendor lock-in,”. Software Impacts, vol. 21, Art. no. 100680, https://www.sciencedirect.com/science/article/pii/S266596382400068X.
Suárez-Otero, P., Mior, M. J., Suárez-Cabal, M. J., & J. Tuya. (2025). “Data migration for column family database evolution,” . Information and Software Technology, vol. 187, Art. no. https://www.sciencedirect.com/science/article/pii/S0950584925001739.
T. Taipalus. (2024). “Database management system performance comparisons: A systematic literature review,”. Journal of Systems and Software, vol. 208, Art. no. 111872, https://www.sciencedirect.com/science/article/pii/S0164121223002674.
Wang, J.-C., Qiu, Z., & Q. Qiu. (2026). “Dynamic data processing, backup and abort strategy for cloud computing systems,” . Reliability Engineering & System Safety, Art. , no. 112835, https://www.sciencedirect.com/science/article/pii/S0951832026006460.
Will, J., Scheinert, D., Zunzer, S., Bode, J., Kring, C., & L. Thamsen. (2024). “Privacypreserving sharing of data analytics runtime metrics for performance modeling,”. in Companion Proc. 15th ACM/SPEC Int. Conf. Performance Engineering, pp. 269–272. https://dl.acm.org/doi/pdf/10.1145/3629527.3652276.
Zbořil, M., & V. Svatá. (2025). “Performance comparison of cloud databases,” . Procedia Computer Science, vol. 256, pp. 388–395, https://www.sciencedirect.com/science/article/pii/S1877050925004910.
Zhao, X., Bu, Y., Pang, W., & J. Cai. (2024). “Periodic and random incremental backup policies in reliability theory,”. Software Quality Journal, vol. 32, no. 3, pp. 1325– 1340, https://link.springer.com/article/10.1007/s11219-024-09685-1.






