Duplicate Oracle database for test environment

Posted on 2011-10-25
Medium Priority
Last Modified: 2012-05-12
we are currently designing a live test environment and need to duplicate the oracle database in the test environment. We don't want to affect the production database of course.  
We will have seperate forests with 2 way trusts between them. Is there a way of coplying the information on the database over to the test domain, perhas a one way synchronization? or would you recommend a backup/restore type of solution?

Thanks in advance
Question by:Marius Gunnerud
LVL 74

Accepted Solution

sdstuber earned 668 total points
ID: 37026951
depends on if you need to keep them up to date or not

if it's a one time (or occasional) synch from production to test,  then backup/restore is fine.

you could also use datapump to do full export/import

you could create a snapshot standby with dataguard

you could use streams replication or 3rd party tools to keep them in synch
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 668 total points
ID: 37026959
You can use RMAN to clone a database.

You should be able to take your backups and restore them to a different server.

If you are looing for a subset of production, I would use export/import.

exp/imp or the new datapump expdp/impdp

the only one that will not bother production is restoring from a backup.
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37026962
>>you could use streams replication or 3rd party tools to keep them in synch

Dangerous since they only want one-way.
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

LVL 35

Assisted Solution

johnsone earned 664 total points
ID: 37027448
Personally, if the two systems are in the same datacenter we used restore.  We would just use the last backup and apply any archive logs we wanted to get it to a certain date/time.

If the two systems were is physically distant datacenters, then we used a physical standby database.  When they wanted a refresh of the test database, we would stop the log apply, shut down the test database and then copy the standby over the test database.  Then bring everything back up.  FYI - it is possible to script this, I don't think I still have the script and it was a little site specific, but it was possible.
LVL 74

Expert Comment

ID: 37027491
>>> Dangerous since they only want one-way.

why is that a problem?  streams can be one way and as for the 3rd party tool, that would, of course, depend on the tool
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37027522
>>>>> Dangerous since they only want one-way.

Sorry.  I was thinking two-way streams and just turning off the apply process on one.  Not sure why I was thinking that.

You would need to write code for the apply process to handle the errors if someone deleted a row in 'test' then production updated it.  The apply process would complain.

LVL 17

Author Comment

by:Marius Gunnerud
ID: 37029408
If the client wants stored procedures from the production environment to also be duplicated in the test environment, would a backup and restore be able to take care of that? If not would you be able to tell me how?
LVL 74

Expert Comment

ID: 37030172
yes backup/restore will move procedures

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

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

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

850 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