Solved

Cloning Oracle database using expdp/impdp

Posted on 2013-01-09
11
2,405 Views
Last Modified: 2013-01-17
How do I clone Oracle database using expdp/impdp?

What is the difference between clonign database and exporting it when using expdp/impdp?
0
Comment
Question by:YZlat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
11 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 38760349
>>How do I clone Oracle database using expdp/impdp?

This really isn't a clone.  You export the schemas from databaseA, create databaseB and import the schemas into it.

>>What is the difference between clonign database and exporting it when using expdp/impdp?

A clone is an EXACT copy of the database.  This is done by copying data files.

export/import extracts the DDL for the objects and the data associated with those objects.  When imported back in, there is a lot of I/O and processing to recreate the objects and load the data (and rebuild any indexes/constriants you had).
0
 
LVL 35

Author Comment

by:YZlat
ID: 38760398
so lets say I need to clone my database from production to developemnt server. What's the best way to do that?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38760416
There really isn't a 'best' way.  It all depends on the specific databases in question and the requirements.

If the database/schemas in question are relativly small, I would probably go with export/import.

The larger the database and amount of data, the less attractive this option.

If you clone, you will have to change the database name.  You probably don't want a development database with the same name as a production database even if they are on different servers.

Changing the name isn't a big deal.  Just one more thing you have to do with a clone.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 35

Author Comment

by:YZlat
ID: 38760442
Can you post step by step instructions on cloning the database? I am new to this, so I need some guidance
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38760458
There are tons of links out there on cloning a database using RMAN if you look around.  Many of them have the steps posted better than I can provide here.

Here's the online doc links for it:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126
0
 
LVL 22

Expert Comment

by:Steve Wales
ID: 38760534
There's an interesting article at the Pythian site that talks about a quick and easy restore if you have an existing RMAN database backup and controlfile backup.

I played with it on a test server and it worked remarkably well.

http://www.pythian.com/library/papers_and_books/the_quick_and_easy_rman_restore/

However, I'd be inclined to stick with the Oracle Documentation and trying to understand how it works step by step before trying to take any shortcuts.
0
 
LVL 35

Author Comment

by:YZlat
ID: 38762815
is RMAN installed separately or is it a part of a standard Oracle installation?
0
 
LVL 35

Author Comment

by:YZlat
ID: 38762868
So cloning the database is the same as restoring database from a backup, is it?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38763094
>>is RMAN installed separately or is it a part of a standard Oracle installation?

It should be part of the normal server install.

>>So cloning the database is the same as restoring database from a backup, is it?

The term 'clone' means an exact copy.  How you achieve the exact copy is up to you.

Restoring from a backup is the most common way.
0
 
LVL 35

Author Comment

by:YZlat
ID: 38766984
how can I backup an Oracle database without using RMAN?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38767056
Shut down the database, copy all the necessary files, start the database back up.

This is typically called a cold-backup.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

751 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