Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle Database 12c Release 2 (12.2.0.1) upgrade using DBUA

  • Posted by Gavin Soorma
  • On March 3, 2017
  • 0 Comments
  • 12.2.0.1, 12c Release 2, dbua, new features, upgrade

Oracle 12c Release 2 (12.2.0.1) was officially released for on-premise deployment yesterday. I tested an upgrade of one of my test 12.1.0.2 databases using the Database Upgrade Assistant (DBUA) and the upgrade went smoothly.

The Parallel Upgrade command line utility catctl.pl has a number of changes and enhancements as compared to 12c Release 1 and I will discuss that in a later post.

Here are the screen shots of the database upgrade process.

 

upg2

 

 

upg1

 

 

upg3

 

 

 

 

 

upg5

 

 

upg6

 

 

upg7 upg8

 

 

upg9

 

 

Note – I only converted my database to NOARCHIVELOG mode because I did not have the recommended free space in the FRA. Don’t do this in production because ideally you would want to either take a backup of archivelogs or last incremental level 1 backup or set a Guaranteed Restore Point so as to be able to Flashback the database if required.

But I did see that the redo generated by the upgrade process seems to far more than that in case of earlier version upgrades. Even the DBUA recommendation was to double the Fast Recovery Area space allocation.

 

upg10

 

 

 

upg11

 

 

upg12

 

 

upg13

 

 

upg14

 

 

upg15

 

 

 

upg16

 

 

 

upg17

 

 

upg19

 

 

upg20

 

 

upg21

 

 

upg22

 1

0 Comments

Leave Reply

Your email address will not be published. Required fields are marked *