Upgrade and Data Migration Methods and Processes

Oracle provides features and products to automate the upgrade process, and to assist you with completing upgrades efficiently.

Oracle Database supports the following methods for upgrading or migrating a database to the new release:

• AutoUpgrade Utility

  Identifies issues before upgrades, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database.

• Manual upgrade using the Parallel Upgrade Utility, and other command-line utilities

  Enables upgrades to be performed using shell scripts.

• Using Fleet Patching and Provisioning (FPP) to upgrade databases.

  In a Fleet Patching and Provisioning (FPP) upgrade (formerly known as Rapid Home Provisioning), you complete a new Oracle Database installation. After testing the database, and modifying it in accordance with the standard operating environment (SOE) that you want to use for your databases, you create an FPP gold image. A DBA deploys instances of that gold image to servers that have earlier release databases that you want to upgrade. After deployment of these gold images, a DBA can run a single rhpctl command to move files, perform configuration changes, and perform other steps required to use the new binaries. Refer to Oracle Clusterware Administration and Deployment Guide for more information about Rapid Home Provisioning.

• Using Oracle Enterprise Manager Fleet Maintenance to upgrade databases.

  Fleet Maintenance, a component of Oracle Enterprise Manager, enables you to use the emcli command-line environment to automatically patch and upgrade a large number of databases in your enterprise. Database Fleet Maintenance enables administrators to maintain groups or pools of Oracle Homes and associated databases by applying database updates that include interim one-off patches, including quarterly security patch updates.

  Fleet Maintenance facilitates the creation of a gold image using a reference environment, or by updating existing gold images by adding desired patches (standard operating environments). With Fleet Maintenance, you can use those gold images, and deploy them across the enterprise for both patching and upgrade with a single emcli command. Fleet Maintenance comes with an extensive set of precheck and intelligent rollback options, and with a user interface that facilitates tracking deployment progress. If there is an issue with patching or upgrade databases, then the Fleet Maintenance user interface can display the specific logs for those databases.

  For more information about Fleet Maintenance, refer to Oracle Enterprise Manager Cloud Control Database Lifecycle Management Administrator's Guide