Minimal Downtime Option for Upgrading Oracle 9i/10G Databases to 11G

1 min read

Jul 10, 2012 12:00:00 AM

This is just a "proxy" blog post with a new title. Yesterday, I published " Migrating your 10G database to ODA with minimal downtime". However, if you read it carefully, the upgrade process described isn't ODA-specific. The only reason I used the title is the fact that the project I am involved in is Oracle Database Appliance (ODA) based. The process can be used for most 11G upgrade projects. Often, a hardware is updated at the same time as a database version. In such cases, we migrate a database from an original location to a new server upgrading the database version and sometimes changing operational system. If this is your situation, you can use the upgrade process to minimize the system's downtime to 1 hour, independently from the size of the database you migrate. In fact, the upgrade process can be used for:

Upgrading Oracle database starting from version 9.2 to newer version
Upgrading Oracle platform to different "bitness" (32 bit to 64 bit)
Changing Oracle platform within a single "endian" (e.g. migrate from Windows to Linux) (2012.07.10 Yury: This options has limitations. Please read the note carefully. Thanks to Jan for pointing it out.)

All with a short downtime. Have a look and and keep it in mind for the next upgrade project!

On this page

Ready to unlock value from your data?

With Pythian, you can accomplish your data transformation goals and more.

Speak with Pythian consultants now →

What We Do

Minimal Downtime Option for Upgrading Oracle 9i/10G Databases to 11G

Share this

Share this

More resources

Oracle 11g ASM Diskgroup Compatibility

How to Upgrade from 11.1.0.7 to 11.2.0.3 on Linux

Case Study: How to Return a Good SQL Execution Plan from 10g Days After an 11g Migration

Ready to unlock value from your data?