Oracle Database Migration Using DataPump

Dear Experts,

Our customer told me that they are planning to migrate their Oracle 11gR2 Database on Windows 2008 R2 ENT to Linux. Database has approximately 3.5 TB of data and they insist on using Oracle DataPump tool for migration.

They asked me for assistance. Could you give me some instructions for how to achieve this migration?  Please give me some hints and  important points to take care of.

Best Regards
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Franck PachotOracle DBACommented:

I don't think it is reasonable to migrate 3.5 TB with datapump.
Just take an export (expdp) and see how long it takes. The see the file size and estimate how long it takes to transfer. Then try to import on a test database, it will be longer. And all indexes have to be rebuild...

You are on same endianess. You can transport tablespace (especially if same storage) or restore backup.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GurcanKAuthor Commented:
What about consistency, guaranteed?
Franck PachotOracle DBACommented:
With transportable tablespace, consistency is guaranteed because you put the tablespaces read only.
With restore of backup (or rman duplicate) consistency is guaranteed by archivelog recovery
johnsoneSenior Oracle DBACommented:
Endianess is not an issue.  RMAN has the functionality to convert files between different operating systems.

The details of doing that are in the manual here ->

It seems like they really want to do it with datapump, so I hadn't posted that information earlier.  But, since it was brought up, that is the way that I would do it.

Since you are trying to move the entire database, I would not consider transportable tablespaces.  You have to create all the users, procedures, packages, functions, etc. on your own.  Not worth the effort when a restore of a backup gets you that for free.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.