The AutoUpgrade utility introduced with Oracle 19c identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database.
In this article we’ll see how this new autoupgrade utility almost completely automates the database upgrade process including pre & post upgrade tasks.
The autoupgrade.jar file is available in the Oracle 19c database software in the $ORACLE_HOME/rdbms/admin directory. The recommendation however is to use the autoupgrade.jar file which can be downloaded from My Oracle Support Document 2485457.1.
oracle> pwd /apps/oracle/server/188.8.131.52/dbhome_1/rdbms/admin oracle> ls -ltr autoupgrade.jar -rw-r--r-- 1 oracle oinstall 3360892 Feb 9 2019 autoupgrade.jar
oracle> $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version build.version 20190207 build.date 2019/02/07 12:35:56 build.label RDBMS_PT.AUTOUPGRADE_LINUX.X64_190205.1800
Below is the diagram to show workflow of an Autoupgrade process:
Below is the diagram to show various Stages in an Autoupgrade process:
There are four AutoUpgrade modes in which autoupgrade.jar can be called:
- Analyze Mode: Setup, Prechecks.
- Fixups Mode: Setup, Prechecks, and Prefixups.
- Deploy Mode: Setup, Preupgrade, Prechecks, guaranteed restore point (GRP), Prefixups, Drain, DB (database) Upgrade, Postchecks, and Postupgrade. You can run your own scripts before the upgrade (Preupgrade stage) or after the upgrade (Postupgrade stage), or both before and after the upgrade.
- Upgrade Mode: Setup, DB (database) Upgrade, Postchecks, and Postfixups.
So as you can see from the workflow and stages, this new autoupgrade utility automates most of the tasks involved in upgrading a database.
In the next post we’ll cover the actual upgrade of Oracle DBs (11gR2, 12cR1, 12cR2, 18cR3) to 19c including both non-CDB and CDB source databases with target database as CDB, covering upgrade as well as conversion from non-cdb to pdb.