Author: biju.thomas

  • Upgrading Oracle Autonomous AI Database with Cross-Region Data Guard from 19c to 26ai

    Upgrading Oracle Autonomous AI Database with Cross-Region Data Guard from 19c to 26ai

    I hear the Autonomous Database upgrade from 19c to 26ai is as easy as a click of a button. Let’s see what is involved and how long it takes.

    As part of ongoing platform modernization efforts, upgrading to the latest long-term support release is essential. I initiated the upgrade of my Autonomous AI Database, ABC19CPRD, moving from Oracle Database 19c to 26ai.

    Currently, the environment is architected for high availability and disaster recovery across two regions:

    Primary Instance: Located in US Midwest (Chicago).

    Local Protection: I also maintain a backup-based local peer for an extra layer of redundancy.

    Remote Standby: A peer database, ABC19CPRD_IAD, is active in US East (Ashburn) using Autonomous Data Guard.

    As you can see, the database is currently 19c, and Oracle shows the “Schedule upgrade to 26ai” option to initiate the upgrade.

    One interesting detail in the OCI console is that the upgrade must be orchestrated from the source. If you attempt to schedule the upgrade from the standby instance in Ashburn, OCI reminds you that upgrades can only be scheduled on the Primary database.

    Once I navigated back to the Chicago primary, the process was straightforward:

    Warning Awareness: OCI provides a clear warning that the database will experience a few minutes of downtime and, importantly, that attached standby databases will be upgraded along with the source.

    I chose the “Schedule upgrade to 26ai” option and opted for the “Earliest available schedule” to get started immediately.

    Oracle provided the schedule within a few minutes, and it is supposed to start at 11:00 PM UTC. The primary database state transitioned to “Updating”.

    The same was visible on the standby side as well.

    Looking at the Work Requests, I can see the operation “Update Autonomous AI Database scheduled time for DB upgrade to 26ai” is currently in progress.

    The upgrade on the primary instance, ABC19CPRD, was the first to move, starting at 11:00:14 PM UTC. It successfully finished its version transition just four minutes later, at 11:04:03 PM UTC.

    The version information in the OCI Portal was updated to show 26ai.

    A query of the banner in V$VERSION confirms the new identity: Oracle AI Database 26ai Enterprise Edition Release 23.26.1.1.0.

    A few minutes after the primary upgrade, standby still shows 19c. Scheduled 26ai upgrade time is the time I scheduled for the primary upgrade.

    After a few minutes, the standby upgrade kicked off.

    I am skeptical of the standby upgrade time – it started and finished immediately according to the work request, but the standby had “Updating” status at the top for 4+ minutes.

    After about 15 minutes of total elapsed time from start to finish, the environment was fully upgraded to 26ai.

    Both the Chicago and Ashburn consoles now proudly display Database Version: 26ai.

    Oracle also initiated the automatic backup shortly after the primary upgrade.

    This is one issue when people use the version in the database name – now my 26ai database is named 19c! Luckily, Autonomous offers an easy way to change the display name. It only changes the display name; the database name remains the same.

    But my autonomous data guard standby instance still has the old display name, and there is no option to change its name.

    That’s it. 15 minutes to upgrade the Autonomous AI Database Serverless from 19c to 26ai.

    Behind the Scenes: Why the Upgrade Is So Fast

    What makes the Autonomous Database upgrade from 19c to 26ai finish in minutes is that it is not a traditional in-place database upgrade.

    In Autonomous Database, compute and storage are decoupled. The database files live on Exadata storage, while the database engine runs on disposable compute. During an upgrade, Oracle does not upgrade binaries in a running database. Instead, Oracle switches the database to a new, pre-provisioned compute stack that is already running the 26ai engine.

    The 26ai Oracle Homes are built, patched, and validated ahead of time across the Autonomous fleet. By the time the upgrade starts, the target engine is already live and tested. The upgrade window is primarily spent draining connections, switching compute, and running final health checks.

    Data dictionary and internal metadata changes are also handled differently. Many transformations are pre-staged or deferred, and several 26ai capabilities are enabled only when first used. This avoids the long-running dictionary upgrade steps that dominate traditional upgrades.

    In short, the speed comes from architecture, not faster scripts. Autonomous Database upgrades work because Oracle controls the full stack and treats the database engine as a replaceable component rather than something that must be upgraded in place.

    Rollback and Alternate Upgrade Options

    Once a scheduled upgrade is initiated in Autonomous Database, it cannot be paused or cancelled, and there is no self-service downgrade option after completion. However, Oracle does provide a limited rollback window (via Oracle Support) if issues are identified shortly after the upgrade, which is possible because the upgrade does not modify data in place. For customers who want to reduce risk further, Oracle also supports full clone and refreshable clone–based upgrades. A refreshable clone allows you to validate application behavior on 26ai while continuously syncing data from the 19c primary, making it ideal for pre-production testing. A full clone, on the other hand, creates a one-time copy that can be upgraded independently and used for functional validation or performance testing before committing to the production upgrade. These options provide a practical safety net when upgrading business-critical workloads.

  • Oracle GoldenGate and Microsoft Fabric: Better Together for Oracle Database@Azure

    Oracle GoldenGate and Microsoft Fabric: Better Together for Oracle Database@Azure

    For years, “multi-cloud” often meant siloed cloud — some workloads in OCI, others in Azure, stitched together with fragile integrations, added latency, and plenty of operational pain.

    With the rollout of Oracle Database@Azure, those walls are finally coming down.

    Oracle databases now run directly inside Azure data centers, with native networking, identity, and billing integration. And quietly — but critically — one of the most powerful additions to this ecosystem is the managed Oracle GoldenGate service, now available natively alongside Oracle Database@Azure.

    Naturally, this raises a question:

    “If I already have Microsoft Fabric for analytics, why do I need GoldenGate? Aren’t they competing?”

    The short answer is no.
    The longer — and more interesting — answer is that GoldenGate and Fabric together form one of the strongest enterprise data architectures available today.

    The End of “Siloed” Multi-Cloud

    Before Oracle Database@Azure, replicating Oracle data into Azure typically meant one of two things:

    • Hairpinning traffic through interconnects
    • Managing your own GoldenGate infrastructure on IaaS

    Both approaches worked, but neither was elegant — and latency was always part of the story.

    With the managed GoldenGate service running physically inside Azure data centers, right next to Oracle Exadata, that changes completely.

    The Latency Game Changer

    GoldenGate now operates co-located with Oracle Database@Azure, allowing:

    • Sub-millisecond latency
    • No public internet traversal
    • No cross-cloud data gravity issues

    Changes are captured and applied without ever leaving Azure’s network backbone. For the first time, Oracle-to-Azure replication feels native — not bolted on.


    GoldenGate vs. Fabric: The Ingestion Misconception

    It’s easy to see why GoldenGate and Fabric get compared.
    Both move data. Both talk about real-time.

    But they solve very different problems.

    • Microsoft Fabric is an analytics and data platform
      Its job is to unify storage (OneLake), compute, governance, BI, and AI. It is where insights are created.
    • Oracle GoldenGate is a data replication engine
      Its job is transactional fidelity, zero-downtime movement, and deep understanding of database internals.

    Fabric’s native mirroring and ingestion tools are excellent for general-purpose scenarios. But when you’re dealing with mission-critical Oracle workloads — complex schemas, high redo volume, strict consistency requirements — a specialized replication engine matters.

    GoldenGate reads Oracle redo logs natively. That’s not just faster — it’s fundamentally more precise.

    A “Better Together” Architecture

    Here’s how these services naturally coexist in a modern Oracle Database@Azure architecture:

    1. The Source
      Mission-critical systems — ERP, core banking, supply chain — run on Oracle Exadata within Oracle Database@Azure.
    2. The Pipe (GoldenGate)
      Managed GoldenGate captures changes in real time with full transactional fidelity.
      It can filter, transform, and even mask sensitive data before it leaves the operational layer.
    3. The Destination (Fabric)
      GoldenGate streams data directly into OneLake or Azure Data Lake Storage, where Microsoft Fabric takes over.
    4. The Insight
      Fabric handles transformations, Spark workloads, semantic models, Power BI dashboards, and AI experiences.

    GoldenGate ensures the data is timely and accurate.
    Fabric ensures the data is usable and valuable.

    Why Not Just Use Fabric Mirroring?

    For simpler use cases, Fabric’s native mirroring is absolutely sufficient.

    But many enterprise Oracle environments demand more:

    • Bi-directional replication (active-active patterns)
    • Conflict detection and resolution
    • Fine-grained filtering and transformations
    • The ability to replicate out of Azure when needed

    GoldenGate has decades of production pedigree in exactly these scenarios. That maturity still matters.

    The Strategic Value

    Beyond architecture, there’s a broader strategic upside:

    • Unified Billing
      Managed GoldenGate consumption counts toward your Microsoft Azure Consumption Commitment (MACC).
    • Best of Breed
      DBAs get the industry standard for Oracle replication.
      Data engineers and analysts get Microsoft Fabric.
    • Future-Proof Multicloud
      Data can move freely — without locking analytics or operations into a single platform.

    Final Thoughts

    Oracle Database@Azure is more than a hosting option — it’s a bridge between two ecosystems.

    In that bridge:

    • GoldenGate is the high-fidelity data movement layer
    • Fabric is the analytics and intelligence layer

    They are not competitors. They are complementary — and together, they finally make integrated multi-cloud real.

    For organizations running critical Oracle workloads on Azure, this isn’t an either/or decision. It’s the blueprint for a modern data estate.