Upgrading Oracle 9i Database to Oracle 10g Database with Near-Zero DowntimePosted: 18/12/2010
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