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

Migrate 6 TB of data from Oracle 8.1.7 to Oracle 10gR2

We have our current production database in Oracle 8.1.7 on Solaris 8, and we are planning to move to Oracle 10gR2. What is the best way to move my data from the 8.1.7 DB?

We have our current production database in Oracle 8.1.7 on Solaris 8, and we are planning on moving to Oracle 10gR2....

This upgrade will be totally on a new Solaris 9 server. I have about 6 terabytes of data with three schemas.

I have the new box ready with 10gR2; what is the best way to move my data from the 8.1.7 DB? Also, I am trying to create a dblink between the two databases but it is not working. Can you give me the correct syntax for creating the dblink?

That's a substantial amount of data to migrate from Oracle8i to 10gR2. The method you choose will depend on the amount of downtime available to you to perform this migration. Export and import isn't really a practical solution here because of the amount of data. The operating system on the new server is Solaris, as is the current server, but it will be a newer release. You should be able to physically copy the database from the existing server to the new server and upgrade it on the new server to 10gR2. This can be done manually by shutting down the database and copying the files, or you can use RMAN to take an offline backup and recover it. This, of course, assumes that the environment on the new server is configured properly for this new database.

The advantage to performing the migration this way is that the back out plan is easy enough … you simply point your application(s) back to the existing 8i database because it will still be available. A word of caution here … I would recommend testing this procedure many times in a non-production environment thoroughly before relying on it as a production migration technique. This testing must include involving your application support and business folks to test all, or at least critical, functions and jobs within their applications after each test migration.

This was last published in April 2007

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.