• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5077
  • Last Modified:

Cloning using RMAN

      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.

1 Solution
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
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now