Skip to Content
  • Database Upgrade Assistant (DBUA)
  • Manual Upgrade
  • Oracle Data Pump Export
  • Standard Import / Original Export and Import
  • Oracle Transportable Tablespaces
  • Oracle Data Guard SQL Apply (Logical Standby)

Each method has its pros and cons, which are described in detail in the Oracle White paper 486336 (http://www.oracle.com/technetwork/database/upgrade/11gr2-upgrade-methods-wp-2011-486336.pdf).

For low and medium important Databases, the DBUA is a good option to consider using as the first choice. Data Pump is better than the old import / export because it is faster and it can be parallelized.

For critical Databases, Export / Import using Datapump is the safest and most conservative. A copy of the original DB will be exported and imported into a new oracle home.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply