Solved

RMAN active clone in 11G

Posted on 2014-10-05
1
187 Views
Last Modified: 2014-10-05
Where do i create the ora password file Source side or target

Where do i create the tns and listener entries Source side or target

Where do i run the command " Duplicate target database xyzp using active database; ( on production or auxillary)
0
Comment
Question by:Venugopal Ganduri
1 Comment
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
1: Databases need a password file so, both but the original should already have one.

2: Both sides but the sources database should have one.  just copy them over to the destination.

3:  You connect to the TARGET which is the source database and use the AUXILIARY  keyword to connect to the destination.

There seems to be a decent example here:
http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php
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.

Join & Write a Comment

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…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example, show how to take different types of Oracle backups using RMAN.
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.

772 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

12 Experts available now in Live!

Get 1:1 Help Now