YZlat
asked on
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?
What is the difference between clonign database and exporting it when using expdp/impdp?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Can you post step by step instructions on cloning the database? I am new to this, so I need some guidance
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
Here's the online doc links for it:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126
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.
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.
ASKER
is RMAN installed separately or is it a part of a standard Oracle installation?
ASKER
So cloning the database is the same as restoring database from a backup, is it?
>>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.
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.
ASKER
how can I backup an Oracle database without using RMAN?
Shut down the database, copy all the necessary files, start the database back up.
This is typically called a cold-backup.
This is typically called a cold-backup.
ASKER