11gR2 Upgrade Hands-on Workshop

Today I completed a two-day hands-on workshop on database upgrades, which was presented by an Oracle employee.

The theory is based on a publicly available presentation on Oracle’s site that has around 500 slides.

No kidding, you have a lot of options when it comes to Oracle database upgrades:

There are a lot of ways to upgrade an Oracle database.

Golden Gate = no downtime at all

Of course, there are restrictions in using some of these methods if you’re running an older release of the DBMS:

For older releases you may need to do a two-step upgrade process.But the best part was the hands-on. I executed 3 database upgrades from 10.2 to 11.2, each one with a different method:

  1. Manually running the admin scripts. (Very few changes from the 11.1 upgrade)
  2. Transportable Tablespaces.
  3. dbua utility. (type dbua, then click next, next, next, … done!)

While the workshop was going on I stopped to think about some other upgrade methods that I’ve already used, some many times:

  1. exp/imp utilities, from an AIX running v7.3.4 to a linux running v8.1.6 and using named pipes to break the dump file (before exp had this feature).
  2. exp/imp utilities, several other times.
  3. expdp/impdp to upgrade from 10.1 to 10.2.
  4. impdp direct dblink connection to upgrade from 10.2 to 11.1.
  5. RMAN to restore and recover a TB-sized 10.2 db and later upgrade it to 11.1 using CLI admin scripts.

Those two slides I got from the presentation that is in the Oracle Database Upgrade site.

This entry was posted in Oracle, Personal and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s