Upgrading Oracle 9i Database to Oracle 10g Database with Near-Zero Downtime

An Oracle database upgrade is a process of transforming an existing Oracle database into a later or the current release of the Oracle Database.

This upgrade process normally requires a significant amount of database down time.

This task of upgrade becomes more difficult for businesses which need to be 24*7 operational and anyoutage negatively affects business operations and customer service. In 24*7 organizations like Banks the database availability is so crucial that the downtime is bargained in minutes. Minimizing downtime is a challenge every organization faces.

Oracle Streams replication enables us to perform an upgrade with near-zero downtime.

This is accomplished by configuring Oracle Streams on the existing Oracle 9i database which captures all the changes on the source database and replicates the changes to thetarget database (Oracle 10g).

The rest of the document presents a step-by-step approach of setting the Oracle Streams replication and performing an upgrade to Oracle 10g database.

See link below

Upgrading Oracle 9i database to Oracle 10g with near zero downtime



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