Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2652
  • Last Modified:

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?
0
YZlat
Asked:
YZlat
  • 5
  • 5
1 Solution
 
slightwv (䄆 Netminder) 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now