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

Cloning using RMAN

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
harris2107
Asked:
harris2107
1 Solution
 
gattu007Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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