7

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?

Improve this question

2 Answers 2

Reset to default
9

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.

Improve this answer
1
  • So I will need to clone the schema to the same instance. Having the right terminology make the difference .Thanks Gaius.
    – StanleyJohns
    Commented Apr 15, 2011 at 18:03
3

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.

Improve this answer
1
  • Instance caging, that is something new. Let me have a look into. Thanks Leigh.
    – StanleyJohns
    Commented Apr 15, 2011 at 18:12

Your Answer

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

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