Solved

Clone database in Oracle Enterprise Manager 11G

Posted on 2010-09-22
2
1,608 Views
Last Modified: 2012-05-10
Hi there,
Just wondering if anyone can help me out with an issue...
I'm trying to clone our production db to our test db, however, using the EM gui, I'm stuck on choosing the Desitnation Oracle Home...when I enter in the host of the Test environment, I get an error stating that the target is not found in the target list managed by Oracle Enterprise Manager. Is there a way to add the test environment in to the production EM? Or am I going about it the wrong way?

I've attached a screenshot of the error...
 
I've taken the Oracle 11GR1 Administration I Workshop, but the Clone Database part will be in Administration II, which I will take in Nov. Apparently the Test users can't wait that long...lol...
Please let me know if you need addition info....

Thanks for your help!
EMError.jpg
0
Comment
Question by:Classic1
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
Comment Utility
I would not add the test database to anything production.

I'm not an OEM user but you should be able to get the location of the files for the clone and copy them over to the test OEM system and import/recover from them.

I believe OEM is actually using RMAN to do this task.  Works case, spend a little time with the RMAN command line to recover/restore.

There are a lot of links on using RMAN to clone a database:
http://www.dba-oracle.com/t_rman_clone+copy_database.htm
0
 

Author Closing Comment

by:Classic1
Comment Utility
Was able to follow the directions/link provided...

Much appreciated,
Classic
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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

763 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

6 Experts available now in Live!

Get 1:1 Help Now