To ensure a trouble free conversion, Oracle suggests that you take several actions before you begin the upgrade or migration of your Oracle database to newest version or latest version of Oracle database. Some of these actions are required only if you are migrating the database. When this is the case, we will note this specifically. Here are the steps you should take to prepare for upgrading or migrating your database. First you should need to become familiar with the new features of latest version Oracle database. |
You should need to check proper SYSTEM tablespace and SYSAUX tablespace space usage and proper free space availability.
If you are upgrading, decide which method to use. If you are upgrading, determine whether you want to do the upgrade manually or use the migration assistant utility.
If you are migrating database with change platform then you should need to advantage of export or data-pump utility.
Determine the system resources required for the conversion.
Create proper action plan to maintain upgrade activity track.
Plan your recovery strategy for any disaster.
Test your conversion process by performing a test migration on a database other than the production database. Conduct this test in an environment as close to the production database environment as possible. Run your test on this platform and validate the results. After upgrading test database, run all applications and reports for further testing.
Prepare and preserve the production database. Schedule the outage time required to do the database upgrade. Perform full backups of the current production. If time allows and database size allows, do an export of the database as well. Always try to keep full cold backup of database as well as Oracle software home. Test your backup to make sure it's recoverable.
Check the all obsolete parameters of new version of database and if any obsolete parameter needs to discontinue then discuss with application team prior to Oracle database upgrade.
Make sure the procedural option is installed. You can determine this by checking the SQL*Plus banner when starting SQL*Plus.
Check all invalid objects and run validation utility to compile. Take final invalid object list from production database before proceed for upgrading.
Make sure sufficient memory available for Oracle instance and check memory requirement for new latest version of Oracle database version.
Remove all pending transactions with all users for any possible unresolved distributed transactions, and resolve them appropriately.
Disable all obsolete parameters from parameters.
Check all tablespaces and data files in the database to be migrated are online.
Before upgrading Oracle database, check Oracle support migration guide properly and follow every action.
About Author: Author is having 15+ years experience and providing Oracle Consulting, and author of Oracle DBA Interview Questions book of Kendba.
Related Articles -
oracle upgrade, oracle migration, database migration,