Consistency-Preserving Incremental Transportable Tablespaces (iTTS) for Near-Zero Downtime Autonomous Database Cutovers
International Journal of Sustainability and Innovation in Engineering · 2026
DOI: 10.56830/ijsie202607 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal of Sustainability and Innovation in Engineering, 2026. Verfasst von Varakala Sowmya. Die Arbeit nennt 41 Literaturangaben.
Abstract (Originalsprache)
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.
Zitieren
APA
Sowmya, V. (2026). Consistency-Preserving Incremental Transportable Tablespaces (iTTS) for Near-Zero Downtime Autonomous Database Cutovers. International Journal of Sustainability and Innovation in Engineering. https://doi.org/10.56830/ijsie202607
Vancouver
Sowmya V. Consistency-Preserving Incremental Transportable Tablespaces (iTTS) for Near-Zero Downtime Autonomous Database Cutovers. International Journal of Sustainability and Innovation in Engineering. 2026. doi:10.56830/ijsie202607
BibTeX
@article{Sowmya2026,
author = {Sowmya, Varakala},
title = {Consistency-Preserving Incremental Transportable Tablespaces (iTTS) for Near-Zero Downtime Autonomous Database Cutovers},
journal = {International Journal of Sustainability and Innovation in Engineering},
year = {2026},
doi = {10.56830/ijsie202607}
}
EUVIMED