What is the best method for moving an Oracle 10g Database to a new server (2003)?

Posted on 2009-02-19
Medium Priority
Last Modified: 2013-12-18
I know this question has been asked many times, but I am just confused by the multiple suggestions and methods mentioned. I need to move an Oracle Database ~5gb in size to a new server. Both Servers are running Oracle 10g ( and Windows Server 2003 Standard. I have installed Oracle Enterprise 10g on the new server and created a database with the same name (orcl). Is it now just a case of me running the 'import' through Oracle Enterprise Manager to import the most current Dump File? Sorry I have very little experience with Oracle so if I could get some basic steps and guidelines to moving an Oracle database I would be most appreciative.
Question by:strata_net
LVL 23

Assisted Solution

David earned 150 total points
ID: 23692214
Welcome to the world of Oracle, and I hope it's a productive experience for you.  I've been at it for about 20 years.  
Some will advise you to use RMAN or DataPump (which I trust you used for your export).  Much will depend upon missing details as to how exactly db2 replicates db1.  For example, does ORCL have the same tablespaces defined, and the same data files on the same directories?  Is the db2 ORCL created, with grants and quotas, but has no objects yet?
A user to user import, ignoring existing table DDL, would be quick, simple, and easy to blow away if problems arose.  An export/import of transferable tablespaces is a great learning experience, and not too painful (copying the tablespace with the databases up).  Another favorite might be to bring both dbs down, copy the ORCL-related data files to db2, replacing the ones there.
One gotcha -- whenever one changes tablespaces, data files, logs, etc. -- very, very good idea to save the pre-change and post-change control file to a human readible text file -- just in case they become corrupted.  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  This may seem like overkill to some, but I like having that action in my db startup and shutdown triggers.  HTH

Accepted Solution

UKReddy earned 225 total points
ID: 23726785

the best way is using RMAN Duplicate database command this will also be achived with less down time

all you need to do is take a backup to tape ,can also be backed up to disk, if the mount point is shared on both the servers its a suggested to backup on to disk, make sure old database is accesseble from new server and run rman commands to duplicate the database.  

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses
Course of the Month16 days, 18 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question