Solved

Cloning using RMAN

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

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.

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

920 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

16 Experts available now in Live!

Get 1:1 Help Now