Cloning Oracle database using expdp/impdp

How do I clone Oracle database using expdp/impdp?

What is the difference between clonign database and exporting it when using expdp/impdp?
LVL 35
YZlatAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>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
 
YZlatAuthor Commented:
so lets say I need to clone my database from production to developemnt server. What's the best way to do that?
0
 
slightwv (䄆 Netminder) Commented:
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
YZlatAuthor Commented:
Can you post step by step instructions on cloning the database? I am new to this, so I need some guidance
0
 
slightwv (䄆 Netminder) Commented:
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
 
Steve WalesSenior Database AdministratorCommented:
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
 
YZlatAuthor Commented:
is RMAN installed separately or is it a part of a standard Oracle installation?
0
 
YZlatAuthor Commented:
So cloning the database is the same as restoring database from a backup, is it?
0
 
slightwv (䄆 Netminder) Commented:
>>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
 
YZlatAuthor Commented:
how can I backup an Oracle database without using RMAN?
0
 
slightwv (䄆 Netminder) Commented:
Shut down the database, copy all the necessary files, start the database back up.

This is typically called a cold-backup.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.