I'm not sure I understand where you plan to create the Oracle8i standby database. Will this reside on the new server? The challenge here is that you are taking a big leap in Oracle database releases (8i to 10gR2), which is going to complicate your migration strategy.
If your plan is to create the standby database on the new server, you must install the Oracle8i software on this server. Oracle8i is not supported, nor certified, for the Solaris 10 operating system, so you may encounter problems installing the software and running the standby database. It is important, when planning these database upgrades and migrations, to review Oracle's Certification Matrix.
On the other hand, Oracle 10gR2 is certified and supported on the Solaris 8 operating system, so, assuming you had the system resources available (memory, disk space, etc.), you could install Oracle 10gR2 software on the existing server and upgrade the database in place with the DBUA or manually via scripts. You could then move the newly upgraded database (using a cold backup, RMAN or transportable tablespaces) from the existing server to the new Solaris 10 server. Note that the Oracle8i database must be at release 18.104.22.168 for you to be able to perform a database migration in place to 10gR2.
For further information on upgrading your database, the Oracle Database 10g Release 2 (10.2) Upgrade Guide provides information on the various upgrade options available, as well as detailed guidelines for developing a test plan. The upgrade path you choose will depend on how large your database is, how long of an outage window you have to perform the upgrade and what type of back-out plan you will require.
Dig Deeper on Oracle database backup and recovery
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.