# Fung's DBA World

## Upgrade Single Database to 12c

March 25, 2016

There are two upgrade approaches, one is with GUI tool DBUA, another is upgrade with manually. This post is focus on manualy upgrade method. After upgrade to 12c, the new version database is non-CDB,which is DEPRECATED by Oracle, so I also will show you how to convert the non-CDB to PDB.

Regarding the PDB and CDB, you can refer my previous topic CDB Overview.
DBUA can automatic backup the database, when upgrade finished, if you’re not satisfied with the result, you can simply restore to previous version if you backup the database with DBUA.

Database version 11.2.0.2 or higher, 10.2.0.5 can be upgraded to 12c directly. Other version should be upgraded to the specific version to meet upgrade requirements.
Assume my new 12c binary code has been install into a new directory: /u02/app/oracle/product/12.1.0/db1/.

#### 1.1 Perform an offline full backup before upgrade

Upgrade is high risk operations in any softwares, whenever you upgrade a database, you should perform a full backup.

#### 1.2 Pre-request check

• Gather Statistics

This step can reduce the amount of downtime.

• Purge recyclebin
• Check the integrity of the source database

EOF