Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I want to clone oracle databases on the same machine and I need to change user etc. from e.g. PROD to DEV. For that I use expdp/impdp, but this tends to be slow with increasing database size. I need to do this on linux and windows machines.
Is using expdp/impdp the fastest way to do this?
Or should I use a completly different way of doing this?
rman is the tool for this.
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm
There is a learning curve, but once configured, it's much faster than export/import.
Like @djb mentioned RMAN is the safest bet, but at times it won't be the fastest solution.
There are other ways, copying database manually comes to mind. It definitely isn't the easiest way and won't be usable if You can't put source database offline for some time.
Pros:
Cons:
I had some strange issues with 10g2 Standard and RMAN, while duplicating database between two completely different configured Linux servers, without any issues with restoring one database on another existing one. This solution allowed me to make fast copies of production database.
In the process, after copying data files, You will have to edit initdb.ora file, ensuring all the path changes. Followed by starting new instance in mount mode and changing name with DBNEWID utility (and changing it in initdb.ora file).
In some cases You could combine both solutions - by making a copy of database with empty data files and restoring source database to copy with RMAN - but with properly configured servers RMAN duplicate will be faster and easier.
Don't know if it is as straightforward or even possible with ASM under Oracle.
You can find more details about duplicating database manually over there:
http://www.dbaref.com/clone-oracle-database/howtocloneadatabasemanuallywithoutusingrman
