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?

2 Answers 2


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.

  • So I will need to clone the schema to the same instance. Having the right terminology make the difference .Thanks Gaius. Apr 15, 2011 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.

  • Instance caging, that is something new. Let me have a look into. Thanks Leigh. Apr 15, 2011 at 18:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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