Oracle 19c AutoUpgrade Best Practices

A Step-by-step Expert-led Database Upgrade Guide to Oracle 19c Using AutoUpgrade Utility

Sambaiah Sammeta, Sukumar Chillakuru, Sambaiah Sammeta, Sukumar Chillakuru

• Publisher: BPB Publications
• Year: 2021
• Topic: Computer Science
• eBook ISBN:
  9789391030902
• Subtopic: Desktop Applications
• Index: Computer Science

Master Oracle's AutoUpgrade tool effectively to upgrade Oracle databases from lower versions to 19c.

Key Features
? In-depth practical demonstration of Oracle database upgrades with various real-time scenarios.
? Step-by-step illustration of each Oracle database upgrade and downgrade method.
? Fastest ever multiple Oracle databases upgrade.

Description
'Oracle 19c AutoUpgrade Best Practices' is a simple cookbook for database professionals to upgrade from lower versions to 19c or downgrade from 19c to lower versionsThis book is dedicated solely to demonstrate upgrading Oracle Databases to 19c by using AutoUpgrade tool. It has a very good explanation about different AutoUpgrade processing modes (Analyze, Fixup, Deploy, and Upgrade) and various stages that the AutoUpgrade job runs while performing database upgrade. Multiple chapters in this book covers various scenarios with detailed steps for upgrading Oracle database from versions 11g/12c/18c to version 19c and Downgrading from 19c to 11g/12c/18c.By the end of this book, every Oracle DBA can gain real-time experience and become a master in upgrading and downgrading oracle databases (Standalone, RAC, Standby) using AutoUpgrade Utility.

What you will learn
? Learn to use the Oracle database upgrade tool AutoUpgrade for various DB challenges.
? Understand how to convert a non-container database to a 19c pluggable database.
? Get to know how to upgrade multiple databases of different versions to 19c in a single operation.

Who this book is for
This book is intended for Oracle DBA students, Database administrators, Database Architects and anyone else who want to improve their database upgrade or downgrade skills in a concise and understandable manner.

Table of Contents
1. Introduction to DB Upgrades
2. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 Using dbupgrade (Manual)
3. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 (Using AutoUpgrade)
4. Upgrading and Converting 12c non-CDB as 19c PDB
5. Upgrading Oracle Multitenant Database from 12c/18c to 19c
6. Upgrading and Converting 12c non-CDB as 19c PDB (using AutoUpgrade)
7. Upgrading Multiple Database Versions (11g/12c/18c) to 19c Using the Single AutoUpgrade Command

CHAPTER 1

Introduction to Database Upgrades

As the lower versions of the databases are getting expired in terms of extended support, Oracle recommends their customers to upgrade their databases to Oracle 19c to run their environments by keeping the database support with the world class database technical experts (Oracle Support).

With Oracle Support, we will know for how long your Oracle database products are being supported. The lifetime support policy gives you the access to get the technical experts’ assistance whenever required, for as long as you have a valid license of your Oracle products. The Oracle Support consists of three support stages – premier support, extended support, and sustaining support. It provides you extreme value with rights to major product releases, so that you can take full advantage of the technology and product enhancement to help your business continue moving forward together.

You will enjoy unremitting the peace of mind by keeping your production databases under support with valid licensing, knowing that we'll always be there to support your business. When it's time to upgrade your database, you will have rights to the major product releases, so that you can benefit from the Oracle's technology leadership and keep pace with the world of business.

The following figure is a pictorial representation of the lifetime support policy of the Oracle database:

Figure 1.1: Database Releases and Support Timelines

Please refer to 'Release Schedule of Current Database Releases (Doc ID 742060.1)' for more details and for the latest updates. This chapter provides an overview on upgrading an existing lower version of the Oracle databases starting from the 11.2.0.4 release to Oracle 19c using the AutoUpgrade utility.

Structure

In this chapter, we will cover the following topics:

• Introduction to the Oracle database upgrade
• Benefits of upgrading the database to 19C
• Oracle database 19c Direct upgrade – supported releases
• Oracle database 19c upgrade methods
• What is AutoUpgrade?
• Overview of the AutoUpgrade stages
• Overview of the AutoUpgrade stage operations and states
• AutoUpgrade processing modes
• Understanding the non-CDB to PDB upgrades with AutoUpgrade

Objective

After studying this chapter, you will be able to understand the database upgrade methods and have a quick overview of the AutoUpgrade utility and its uses.

Introduction to the Oracle database upgrade

As an Oracle Database Administrator, we are familiar with the terminology called Upgrading and Migrating the Databases. Before getting into the actual technical details, we would like to recall the differences between these two terminologies, which are as follows:

• Database upgrade: Upgrading an existing Oracle database into a higher release means that the data dictionary for the database is upgraded to the new release. During the database upgrade, we would not change or move the customer data which is inside the database.
• Database migration: This means that moving the data from one database to another in a new operating system or a new hardware or to a new character set. Migration does not include the database upgrade and it should be separately handled after the database migration is completed successfully.

Benefits of upgrading the database to 19c

Oracle has released a couple of new features in the Oracle database 19c; the following is a list of those that are majorly used in the daily DBA's activities:

• Automated installation, configuration, and patching
• AutoUpgrade and database utilities
• Database in-memory wait on populate
• Resource manager automatically enabled for database in-memory
• Memoptimized Rowstore Fast Ingest
• Automatic Database Diagnostic Monitor (ADDM) Support for Pluggable Databases (PDBs)
• Resource manager automatically enabled for database in-memory
• High-frequency SQL Plan Management Evolve Advisor Task
• Workload capture and replay in a PDB
• Automated PDB Relocation
• Zero-Downtime Oracle Grid Infrastructure Patching
• Automated transaction draining for Oracle Grid Infrastructure upgrades
• Oracle restart patching and upgrading
• Many other security features

Oracle database 19c direct upgrade – supported releases

We can perform a direct upgrade of the Oracle database to the new release from the following releases (refer figure 1.2):

• Oracle 11g (11.2.0.4)
• Oracle 12c (12.1.0.2)
• Oracle 12c (12.2.0.1)
• Oracle 18c

In case we want to upgrade the earlier database to the 11.2.0.4 release, then we cannot directly upgrade to the higher releases – 12c, 18c, or 19c. In such cases, we need to upgrade the database to the intermediate release before upgrading to 19c.

Take a look at the following example:

If you are planning to upgrade a database from release 9.2.0.8, then you must first upgrade to a sequence of intermediate Oracle database releases, i.e., upgrade from release 9.2.0.8 to release 11.2.0.4, and then upgrade from release 11.2.0.4 to Oracle 19c.

If you are planning to upgrade a database from release 10.1.0.5, 10.2.0.2, 10.2.0.3, 10.2.0.4, or 10.2.0.5, then you must upgrade the database to release 11.2.0.4 or 12.1.0.2. If you are planning to upgrade a database from release 11.2.0.2 or 11.1.0.7, then you must upgrade to the intermediate release – Oracle database 11g release 2 (11.2.0.4) – which is supported for direct upgrade to the Oracle database 19c.

Each and every case can be different from that of the examples provided here, as we have multiple available versions of the Oracle databases.

Figure 1.2 represents the pictorial representation of the supported releases for the Oracle 19c Database direct upgrade.

Figure 1.2: Oracle 19c Database direct upgrade – supported releases

Oracle database release with support dates

The following table illustrates the support date schedule for each Oracle database release:

Release	GA Date	Premier support ends	Extended support ends	Sustaining support ends
8.1.7	Sep 2000	Dec 2004	Dec 2006	Indefinite
9.2	Jul 2002	Jul 2007	Jul 2010	Indefinite
10.1	Jan 2004	Jan 2009	Jan 2012	Indefinite
10.2	Jul 200	5Jul 2010	Jul 2013	Indefinite
11.1	Aug 2007	Aug 2012	Aug 2015	Indefinite
11.2	Sep 2009	Jan 2015	Dec 2020	In...

Table of contents

• Cover Page
• Title Page
• Copyright Page
• Foreword
• Dedication Page
• About the Authors
• About the Reviewers
• Acknowledgements
• Preface
• Errata
• Table of Contents
• 1. Introduction to Database Upgrades
• 2. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 Using dbupgrade (Manual)
• 3. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 (Using AutoUpgrade)
• 4. Upgrading and Converting 12c Non-CDB as 19c PDB
• 5. Upgrading Oracle Multitenant Database From 12c/18c to 19c
• 6. Upgrading and Converting 12c Non-CDB as 19c PDB (Using AutoUpgrade)
• 7. Upgrading Multiple Database Versions (11g/12c/18c) to 19c Using a Single AutoUpgrade Command
• Index