• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2774
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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