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:
Of course, there are restrictions in using some of these methods if you’re running an older release of the DBMS:
- Manually running the admin scripts. (Very few changes from the 11.1 upgrade)
- Transportable Tablespaces.
- 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:
- 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).
- exp/imp utilities, several other times.
- expdp/impdp to upgrade from 10.1 to 10.2.
- impdp direct dblink connection to upgrade from 10.2 to 11.1.
- 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.