11g rman active database duplication

Posted on 2011-09-12
Medium Priority
Last Modified: 2012-05-12
We have a DB server that hosts  a DB, we need to use RMAN 11g active duplication to duplicate the DB to a new host;
Can we duplicate this DB to the new host and end up with a database(on the new host) that has the same db_name and instance_name.
For RMAN 11g active duplication I know that the newly created DB will have a new DBID;
but we want to also to keep the same db_name and sid_name.
Is this possible?

Question by:it-rex
  • 2
  • 2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36524596
I've never done it but cannot think of a reason you cannot use the same names on a different server as long as you understand the potential problems having two databases with the same name.

If there some reason you think you might not be able to do this?
LVL 11

Author Comment

ID: 36524811
Not really,was just wondering.
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 36530344
I read a little about active duplication and it sort of implies you get a database with the same name.

There is a reference in the docs for DB_NAME but only when sharing ORALCE_HOMES:



The same name used in the DUPLICATE command.
The DB_NAME setting for the duplicate database must be unique among databases in its Oracle home.

Accepted Solution

Piloute earned 1600 total points
ID: 36530653

RMAN duplication (active or not) implies a new DBID. But there's no restriction about what your db name is. It works fine even if you go for the same name (tested on 11.2/linux).

LVL 11

Author Closing Comment

ID: 36531419

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question