Oracle 19c AutoUpgrade Best Practices
US$ 19.95
The publisher has enabled DRM protection, which means that you need to use the BookFusion iOS, Android or Web app to read this eBook. This eBook cannot be used outside of the BookFusion platform.
Description
Contents
Reviews
Language
English
ISBN
9789391030902
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
Structure
Objective
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
AutoUpgrade
Overview of AutoUpgrade stages
Overview of the AutoUpgrade stage operations and states
Understanding the operation messages
Understanding the state messages
AutoUpgrade processing modes
Understanding the non-CDB to PDB upgrades with AutoUpgrade
Conclusion
2. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 Using dbupgrade (Manual)
Introduction
Structure
Objective
An overview of database upgrade
High-level steps performed as part of this upgrade activity
Environments used for the upgrade
Setting up the source environment
Setting up the target environment setup
Pre-requisites of the database upgrade
Perform full backup of primary source database
Enable the flashback feature in the primary source database
Enable Flashback feature in physical standby database
Ensure enough space is available in Fast Recovery Area (FRA)
Upgrade of Application Express (APEX)
Purge recyclebin
Gather dictionary statistics
Ensure that the physical standby database is in sync with the primary database
Upgrading the Oracle 11g (11.2.0.4) database to Oracle 19c (19.9.0)
About the parallel upgrade utility (catctl.pl and dbupgrade)
Disable the dataguard broker
Disable the Fast Start Failover (FSFO) if it’s enabled
Disable the dataguard broker configuration
Stop the data guard broker (DMON) process in the primary database
Backup DB broker configuration files
Working directories
Network files
Primary database initialization parameter (pfile/spfile) files
Password files
Check the INVALID objects count in the primary database
Running the pre-upgrade script pre-upgrade jar file
Creating Guaranteed Restore Point (GRP) in physical standby database
Shutdown the Physical standby database
Run preupgrade fixup scripts in the source primary database
Create Flashback GRP in the primary database
Start the primary database in the upgrade mode from the 19c homes
About dbupgrade utility
Running post upgrade fixup script
Timezone upgrade
Time zone upgrade check script
Run the Timezone upgrade script
Upgrade clusterware configuration of a database
Check for the post upgrade invalid objects
Upgrading the physical standby database to Oracle 19c (19.9.0)
Standby database upgrade precheck steps
Post upgrade tasks
Fallback using Flashback to GRP
Downgrading the primary database
Downgrading the physical standby database
Downgrade the standby database's clusterware configuration of the database
Recreate the data guard broker configuration
Conclusion
Multiple choice questions
Answers
3. Upgrading Oracle Database from 11.2.0.4 to 19.9.0 (Using AutoUpgrade)
Introduction
Structure
Objectives
The AutoUpgrade utility
Support of the AutoUpgrade utility
Installing the AutoUpgrade utility
Configuration File of AutoUpgrade Utility
Configuration file parameters of AutoUpgrade
Global parameters
Local parameters
AutoUpgrade version
AutoUpgrade jar file options
AutoUpgrade error codes
Oracle database upgrade process using AutoUpgrade
Processing modes of AutoUpgrade
Stages of AutoUpgrade utility
Console commands of AutoUpgrade
Restarting an AutoUpgrade job
Logs of AutoUpgrade
Upgrading RAC database from Oracle 11g (11.2.0.4) to Oracle 19c (19.9.0)
High-level steps of the AutoUpgrade process
Check the configuration of primary database and physical standby database
Setting up the source environment
Setting up the target environment
Pre-requisites
Perform full backup of primary source database
Enable flashback feature in primary source database
Enable flashback in physical standby database
Ensure enough space in Fast Recovery Area (FRA)
Gather dictionary statistics
Purge recyclebin
Hidden parameters
Upgrade of Application Express (APEX)
Ensure that the physical standby database is in sync with the primary database
Creating Guaranteed Restore Point (GRP) in the physical standby database
Upgrading Oracle 11g (11.2.0.4) database to 19c (19.9.0)
Disable Dataguard broker
Standby sync check before disabling dataguard broker
Disable Fast start failover (FSFO) if it’s enabled
Disable the dataguard broker configuration
Stop the data guard broker (DMON) process in the primary database
Working directories
Network files
Primary database initialization parameter (pfile/spfile) files
Password files
Check the INVALID objects’ counts in the primary database
Download the latest AutoUpgrade tool
Configuration file creation for AutoUpgrade
Running AutoUpgrade in the Analyze mode
Shutdown the physical standby database
Upgrade the primary database using AutoUpgrade
Check for the post upgrade invalid objects
Upgrading the physical standby database to Oracle 19c (19.9.0)
Start the data guard broker process in both the primary and the physical standby database
Perform the final check to confirm that both the primary and the physical standby database are upgraded to Oracle 19c (19.9.0)
Post upgrade tasks
Oracle database downgrade
Oracle database downgrade methods
High-level steps performed as part of this downgrade activity
Important note on a known bug
Pre-downgrade steps/checks
Check for incompatibilities when downgrading the Oracle Database
Take a full backup of the primary database before proceeding with the downgrade
Disable the Oracle database vault
Downgrade Oracle Label Security
Purging audit trail files
Checking Timezone file in the primary database server
Standby lag check
Shutdown the standby database
Downgrade primary database
Database downgrade
Downgrading the Timezone
Downgrading the physical standby database to Oracle 11g (11.2.0.4)
Known issues
Issue-1
Issue-2
Issue-3
Issue-4
Issue-5
Conclusion
Multiple choice questions
Answers
Key terms
4. Upgrading and Converting 12c Non-CDB as 19c PDB
Introduction
Structure
Objective
An overview of Database upgrade demonstrated in this chapter
High-level steps that are performed as part of this upgrade and pdb conversion activity
Check the configuration of the primary database and the physical standby database
Setting up the Source Environment
Setting up the target environment
Pre-requisites
Perform full backup of the primary source database
Enable the flashback feature in the primary source database
Enable Flashback in the physical standby database
Ensure enough space is available in Fast Recovery Area (FRA)
Purge recyclebin
Gather dictionary statistics
Upgrade of Application Express (APEX)
Upgrading Oracle 12c (12.1.0.2) database to oracle 18c (19.9.0)
Disable the dataguard broker
Disable the Fast start failover (FSFO) if it's enabled
Disable the dataguard broker configuration
Stop the data guard broker (DMON) process in the primary database
Working directories
Network files
Primary database initialization parameter (pfile/spfile) files
Password files
Check the INVALID objects' counts in the primary database
Download the latest AutoUpgrade tool
Configuration file creation for AutoUpgrade
Modify the configuration file for this upgrade
Running AutoUpgrade in Analyze mode
Creating GRP in the physical standby database
Shutdown the physical standby database
Upgrade the primary database using AutoUpgrade
Check for the post upgrade invalid objects
Upgrading physical standby database to Oracle 19c (19.9.0)
Start the data guard broker process in both the primary and the standby databases
Fallback method
Post upgrade tasks
Conversion of non-CDB as a pluggable database (PDB)
Reusing datafiles in the Standby datafiles during PDB conversion
Standby lag check
Obtain the GUID of the from texapr (non-cdb primary database(texapr)
Creating aliases for the non-cdb standby database (texadr) datafiles
Export of TDE keys
Creation of Manifest file
Shutdown the non-cdb primary and standby databases
Plug the non-cdb primary database into the 19.9.0 container database
Stop the cdb Physical Standby database (questdr)
Create the pluggable database
Check the PDB violations
Pluggable database conversion
Re-check the PDB violations
Importing the TDE keys into the Pluggable database, texapr
Fallback method
Known issues
Issue-1
Issue-2
Conclusion
Multiple choice questions
Answers
Key terms
5. Upgrading Oracle Multitenant Database From 12c/18c to 19c
Introduction
Structure
Objective
Scenarios demonstrated in this chapter
Scenario-1: Upgrading the container database along with all the pluggable databases to the Oracle 19c container database
High-level steps that are performed as part of this upgrade activity
Check the configuration of the primary database and the physical standby database
Setting up the source environment
Setting up the target environment
Pre-requisites
Perform full backup of the primary source database
Enable the flashback feature in the primary source database
Enable the flashback feature in the source physical standby database
Ensure enough space is available in Fast Recovery Area (FRA)
Purge recyclebin
Gather the dictionary statistics
Creating GRP in physical standby database
Upgrading the Application Express (APEX)
Upgrading the database Oracle 12c (12.1.0.2) to Oracle 19c (19.9.0)
Disable the dataguard broker
Disable the dataguard broker configuration.
Disable the Fast start failover if it is enabled
Stop the data guard broker (DMON) process in the primary database
Backup DB broker configuration files for primary database
Backup the dataguard configuration files of the physical standby database
Working directories
Copy the required Oracle database configuration files
Network files
Checking sqlnet.ora file entries
Primary database initialization parameter (pfile/spfile) files
Password files
Check the INVALID objects’ counts in the primary database
Download the latest AutoUpgrade tool
Configuration file creation for AutoUpgrade
Running AutoUpgrade in Analyze mode
Log files of AutoUpgrade
Shutdown the physical standby database
Upgrade the primary database using AutoUpgrade
Check for the post upgrade invalid objects
Upgrading the physical standby database to Oracle 19c (19.9.0)
Start the broker in both primary and standby databases
Post upgrade tasks
Fallback using Flashback to GRP
Downgrade using the Flashback method
Downgrading the primary database
Downgrading the physical standby database
Recreate the data guard broker configuration
Scenario-2: Upgrading a single pluggable database from the source container database to the target Oracle 19c container database
The high-level steps performed as part of this upgrade activity
Check the configuration of the primary database and the physical standby database
Setting up the source environment
Setting up the target database environment
Working directories
Configuration file
Running AutoUpgrade in the Analyze mode
Database upgrade log files
Run the AutoUpgrade command in the DEPLOY mode to upgrade the database
Post upgrade steps
Known issues
Issue-1
Conclusion
Multiple choice questions
Answers
Key terms
6. Upgrading and Converting 12c Non-CDB as 19c PDB (Using AutoUpgrade)
Introduction
Structure
Objective
An overview of the database upgrade
Environments used for the upgrade
Setting up the source database environment
Setting up the target environment
Pre-requisites of database upgrade
Perform full backup of the primary source database
Enabling flashback in the source database
Purge recyclebin
Gather the dictionary statistics
Working directories
Download the latest AutoUpgrade tool
AutoUpgrade Configuration file
Upgrading database Oracle 12c (12.1.0.2) to Oracle 19c (19.9.0)
Running AutoUpgrade in the Analyze mode
AutoUpgrade log file location
Running the AutoUpgrade command in 'DEPLOY' mode
Post upgrade checks
Fallback method
Known issues
Issue-1
Issue-2
Conclusion
Multiple choice questions
Answers
Key terms
References
7. Upgrading Multiple Database Versions (11g/12c/18c) to 19c Using a Single AutoUpgrade Command
Introduction
Structure
Objective
An overview of the database upgrade
Setting up the source environment
Setting up the target environment
Pre-requisite checks required for the database upgrades
Perform a full backup of the primary source database
Enabling flashback in the source database
Check and make sure we have enough space in FRA
Purge recyclebin
Gather dictionary statistics
Working directories
Check the INVALID objects’ count in the primary database
Download the latest AutoUpgrade tool
AutoUpgrade version
Configuration file
Upgrading Oracle 11g (11.2.0.4)/12c (12.1.0.2) and 18c (18.3.0.0) databases to Oracle 19c (19.9.0)
Running AutoUpgrade in Analyze mode
AutoUpgrade log file location
Preupgrade summary
Run the AutoUpgrade command in the DEPLOY mode
Post upgrade checks
Oratab entries
Check the GRP information for each database
Multiple instances of the AutoUpgrade process
Fallback method
Conclusion
Multiple choice questions
Answers
Key terms
Index
The book hasn't received reviews yet.