My Oracle Support Banner

Oracle Exadata Database Service 19c Rolling Upgrade with DBMS_ROLLING from Oracle Database (Doc ID 2889464.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Gen 2 Exadata Cloud at Customer - Version N/A to N/A [Release All Releases]
Information in this document applies to any platform.


This document provides step-by-step instructions for database 19c rolling upgrade with DBMS_ROLLING, from Oracle Database to Oracle Database Release 19c on Oracle Exadata Database Service on Dedicated Infrastructure and Exadata Cloud at Oracle Exadata Database Service on Cloud@Customer.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Phase 1 - Database 19c DBMS_ROLLING Upgrade Prerequisites
 Step 1.1 – Validate Upgrade Steps on Test
 Step 1.2 - Validate Minimum Software Requirements
 Step 1.2.1 - Golden Gate Supported Versions
 Step 1.2.2 - Oracle Application Express (APEX) Supported Versions
 Step 1.2.3 - Required Exadata Database Server Software Version
 Step 1.2.4 - Required Grid Infrastructure Version
 Step 1.3 - Check the status and version of the primary and standby database
 Step 1.4 - Check that all data types are supported on a logical standby database
 Step 1.5 - Run Latest EXAchk and Address Critical Alerts
 Step 1.6 - Prepare Target 19c Oracle Home on the Primary and Standby Systems
 Step 1.7 - Run PreUpgrade Information Tool on the Primary Database
 Step 1.7.1 – Run PreReqs on Primary Database
 Step 1.7.2 - Review PreUpgrade Information Tool Output
 Step 1.8 - Evaluate checklist for continuous application service during maintenance window
 Phase 2 – Upgrade the Database to 19c using DBMS_ROLLING
 Step 2.1 - Planning a Rolling Upgrade
 Step 2.1.1 – Set the Standby database in MOUNT State
 Step 2.1.2 – Check the Standby LAG
 Step 2.1.3 - Initialize the Plan
 Step 2.1.4 - Display the parameters for the current plan build
 Step 2.1.5 - Build the Upgrade Plan
 Step 2.1.6 - Display the Plan
 Step 2.2 - Performing a Rolling Upgrade
 Step 2.2.1 - Disable Data Guard Broker
 Step 2.2.2 - Run Start Plan
 Step 2.2.3 - Open and Verify that the Standby Database is Successfully Converted
 Step 2.2.4 - Start Apply in the Transient Logical Standby Database
 Step 2.2.5 - Run PreUpgrade Information Tool on the Transient Logical Standby Database
 Step – Run PreReqs on Transient Logical Standby Database
 Step - Review PreUpgrade Information Tool Output
 Step 2.2.6 - Upgrade the Standby Database
 Step 2.2.7 - Start Logical Standby Apply
 Step 2.2.8 - Perform the Switchover 
  Step 2.2.9 - Modify the Database Roles
 Step 2.2.10 - Move the New Physical Standby (former primary database) to New 19c Database Oracle Home
 Step 2.2.11 - Enable Data Guard Broker Start and Mount the New Standby as Single Instance
 Step 2.2.12 - Execute DBMS_ROLLING.FINISH_PLAN and Enable Data Guard Broker
 Step 2.2.13 – Start all the Database Instances
 Phase 3 - Post Upgrade Steps
 Step 3.1 – Validate the New Standby Database
 Step 3.2 - Post DBMS_ROLLING Upgrade Tasks
 Step 3.3 – Enable Oracle Active Data Guard (Optional)
 Step 3.4 – Switchover the database roles
 Step 3.5 - Validate the version and statuses of the databases
 Step 3.6 – Destroy the DBMS_ROLLING Plan
 Step 3.7 - Drop Guaranteed Restore Point on Standby and Primary
 Revision History

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.