Duplicate Oracle database for test environment

Posted on 2011-10-25
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:MAG03
    LVL 73

    Accepted Solution

    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 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    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 76

    Expert Comment

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

    Dangerous since they only want one-way.
    LVL 34

    Assisted Solution

    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 73

    Expert Comment

    >>> 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 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    >>>>> 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

    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 73

    Expert Comment

    yes backup/restore will move procedures

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Title # Comments Views Activity
    Retire Active Directory server 3 19
    AD FS DNS 4 23
    Trust relationship SBS2011 - > Windows 2003 3 18
    oracle query help 36 38
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now