expdp impdp vs RMAN backup restore [message #607448] |
Thu, 06 February 2014 12:53 |
|
anncao
Messages: 87 Registered: August 2013
|
Member |
|
|
New to oracle, I worked on SQL server environment before to restore production database to test for developers to work on it using backup and restore method in SQL server.
But I see in our new oracle environment, someone set up like this:
using expdp and impdp script to restore production database to test database.
I know oracle also has RMAN that can backup and restore.
So not sure why they use expdb and impdp vs RMAN restore method.
Any pro and cons of each?
Thanks
|
|
|
|
|
Re: expdp impdp vs RMAN backup restore [message #607457 is a reply to message #607456] |
Thu, 06 February 2014 15:41 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Well, I'm an (somewhat) old geezer and still a little partial to the third option you have, Online User-Managed Backup. Which has become more interesting in the last years, depending on your underlying storage system.
For example, or database is store on a NetApp storage cluster. When I need a new test Instance I can switch the production DB into online backup mode, take a FlexClone of the database files, and switch the backup mode off again. That takes ~5 seconds. Then I can mount that clone on the test instance and start the test database up. That way we usually only need ~10GB of additional delta blocks in the storage over the day for having a test instance of a ~850GB database.
And it's done in ~30-40 seconds from the moment I decide I need a snapshot to the point where the cloned test instance is running.
|
|
|
|