Solved

Cloning using RMAN

Posted on 2007-04-06
1
5,071 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 500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

691 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