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?

Nick Chammas
  • 14,810
  • 17
  • 76
  • 124
StanleyJohns
  • 5,982
  • 2
  • 25
  • 44

2 Answers2

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.

Gaius
  • 11,238
  • 3
  • 32
  • 64
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.

Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155