If your environment must be available 24x7, this will narrow down your options for migrating your Oracle database....
I have not used Streams to perform an upgrade but, since it is not mentioned in the Oracle Database Upgrade Guide 10g Release 2 (10.2), I would be tempted to open a TAR with Oracle Support and ask whether this is a supported migration method.
Basically, your options are as follows:
- Create a new, empty database on the new Solaris 10 host with all the relevant application data and index tablespaces. Export the relevant schemas (or the entire Oracle 9.2) database and then import it into the newly created 10g database on the new host.
- Create a new, empty database on the new Solaris 10 host. Make sure you create all the relevant tablespaces, as well as any userids and roles. Create a database link from the 10g database to the 9.2 database and use CTAS (create table as select) commands to bring over the data. After this is completed, you must also create any relevant indexes, as well as other objects such as function, procedures, sequences, etc.
Both of these methods will require some downtime, possibly a significant amount of downtime if the database is large.
A final option is to install the Oracle 10g database software on the Solaris 8 host where the database currently resides and upgrade the database in place to 10g. Whether this option is viable depends on several factors, one being whether this database server has the required system resources to run a 10g database. This option may offer less downtime than the two options above. It will be difficult to find a method for migrating your database that offers true zero downtime. There may be some third-party products that offer this capability, so it might be worth asking other DBAs in your community whether they have researched any third-party products that offer this.
Dig Deeper on Oracle database export, import and migration
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.