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's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In SQL server I can restore a database onto the same instance with a different name. Eg: If there is a database DB_prod, I can take a full backup and restore it on the same instance with a different name like DB_test.

Is a similar task possible with Oracle?

share|improve this question
up vote 9 down vote accepted

Easily - just use RMAN to clone it. I think you mean in Oracle terminology, clone the database into a new instance on the same server. If you really do mean clone the schema into the same Oracle instance, then the easiest way is Datapump.

share|improve this answer
So I will need to clone the schema to the same instance. Having the right terminology make the difference .Thanks Gaius. – StanleyJohns Apr 15 '11 at 18:03

Gaius has the correct answer+1. You should consider virtualizing the server to run both the original and the clone in separate virtual machines. It makes the setup of the clone considerably simpler and can help with managing the priorities between the two instances. If that is not possible and you are on 11.2+ you should look at instance caging.

share|improve this answer
Instance caging, that is something new. Let me have a look into. Thanks Leigh. – StanleyJohns Apr 15 '11 at 18:12

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.