Problem solve Get help with specific problems with your technologies, process and projects.

Database too large for exp/imp migration

I am migrating an Oracle 8i database to Oracle 10g. The DB is too large for imp/exp. Can I create a standby database on 8i first, switch to production and then migrate to 10g?

I have to move an Oracle 8i database (32-bit) on a Solaris 8 machine to Oracle 10g (64-bit) on a Solaris 10 machine. The DB is too large for imp/exp. I am thinking of trying to create a standby database on 8i first, switch to production and then migrate to 10g. Is there a better way?

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 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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.