?
Solved

Cloning using RMAN

Posted on 2007-04-06
1
Medium Priority
?
5,072 Views
Last Modified: 2013-12-21
Hi,
      Im trying to clone a database using RMAN DUPLICATE command. I have gone through the documents and was able to get a basic idea of how to do it. Im still suspicious whether i got the answers for the following situations

1) Suppose we have RMAN recovery catalog on host A and we are trying to clone the database  DB1 on host B onto host C. Can we clone the databse DB1 on the same host i.e., host B? It is not possible for RMAN to connect to 2 target databases at a time right, except in the came where we perform cloning and connect to an AUXILIARY instance (?).

2) I heard we can perform a manual cloning of a database on the same host provided it has different INSTANCE_NAME set though the DB_NAME can be the same. Did i get that right? What is the use of the parameter DB_UNIQUE_NAME, which can also be used in cloning sometimes?

Any information will be of a great help.

Thanks.
Harris
0
Comment
Question by:harris2107
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
gattu007 earned 2000 total points
ID: 18863973
You can clone on the same host...
You can never connect to 2 targets...

in your case

host A  is catalog
host B is target
host C is auxiliary

when you do manual cloning make sure you change the dbid of the database. if you do it by rman duplicate ... then rman automatically takes care of it..

DB_UNIQUE_NAME specifies a globally unique name for the database. Databases with the same DB_NAME within the same DB_DOMAIN (for example, copies of a database created for reporting or a physical standby) must have a unique DB_UNIQUE_NAME. Every database's DB_UNIQUE_NAME must be unique within the enterprise.


metalink References:
=========
Subject:       RMAN 'Duplicate Database' Feature in Oracle9i / Oracle 10G
        Doc ID:       Note:228257.1

Subject:       Oracle10G RMAN Database Duplication
        Doc ID:       Note:259694.1
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month12 days, 2 hours left to enroll

752 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