Q

Moving database to new, larger server

We are moving from an old server to a new, larger server. I have a 8.0.5 database which is about 20 GB. Can you recommend the best way to move this file over?

We are moving from an old server to a new, larger server. I have a 8.0.5 database which is about 20 GB. Can you recommend the best way to move this file over?
When moving from one physical server to another, one of the best ways to perform this operation is to use Oracle's Export and Import utilities. By using exp and imp, you can enjoy these benefits:

  1. You can go from one OS platform to another; for instance the old db server could be Sun Solaris and the new one can be Linux.
  2. You can upgrade at the same time. Create a dump file with your Oracle 8.0.5 software. Then use Oracle 10g's imp utility to import into your new 10g database on the new db server. The database will be upgraded in this step.
  3. You can perform any database reorganizations you need to do at the same time.
  4. You can change the DB_BLOCK_SIZE if needed at this time.

The downside to using exp and imp is that a larger database can take a long time to import. However, 20GB is not that large of a database so I would probably use exp and imp for my database move to the new server. Use these steps:

  1. On the new db server, install the Oracle software and precreate any tablespaces you'll need.
  2. Optionally, precreate any users you'll need in the new database.
  3. On the old database server, take a full export of your database:
       exp userid=system/manager file=full.dmp log=exp.log full=y
    
    I always log my session's output for reference.
  4. FTP the dump file to the new database server in binary mode.
  5. Import the dump file's contents on the new database server:
       imp userid=system/manager file=full.dpm log=imp.log full=y
    

That should complete your move!

This was first published in October 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close