Solved

11g rman active database duplication

Posted on 2011-09-12
5
650 Views
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?

thanks,
0
Comment
Question by:it-rex
  • 2
  • 2
5 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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?
0
 
LVL 11

Author Comment

by:it-rex
Comment Utility
Not really,was just wondering.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 100 total points
Comment Utility
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:

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmdupdb.htm

DB_NAME
 

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.
 
0
 
LVL 7

Accepted Solution

by:
Piloute earned 400 total points
Comment Utility
Hi,

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).

Cheers,
P
0
 
LVL 11

Author Closing Comment

by:it-rex
Comment Utility
thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
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 about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now