Refreshing a development DB with production backup

Posted on 2011-03-23
Last Modified: 2013-12-19
My manager has asked me to do a data refresh of a development database with production data(via backup) I don't know where to start. Can someone provide me some steps on how to get this process started? Thanks!
Question by:themeeper1
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35199889
How was production backed up?

You should have procedures on restoring and recovery from this backup.

Go through those steps but on the development server.  Depending on the backups you are performing, you might need to change the database name once on development.

Author Comment

ID: 35199927
production is backed up using RMAN and a full hot backup. I don't have any procedures on restoring. I think the first step is to copy a init.ora file from production to the development network right?
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35199958
If you've never done this before, I would be very cautious.

There are a TON of links out there on duplicating/copying a database using RMAN:
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.

LVL 37

Accepted Solution

Geert Gruwez earned 500 total points
ID: 35204680
you don't really need the backup
the safest way:

from the development database, create a db link to the production database
create database link proddb connect to user identified by password using

then, on the development database
for each table you want data from the production database
insert into table (field1, field2, fieldn) select field1, field2, fieldn from table@proddb;

you might want to look into the sqlplus tool for scripting
LVL 12

Expert Comment

ID: 35205400

check some of the RMAN Recovery Scenarios which may suit as per you requirment.
LVL 12

Expert Comment

ID: 35205410
and you can also use RMAN Duplicate command check this doc for more details.
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35206289
>>from the development database, create a db link to the production database

I would never recommend linking your development or test databases to production.  Way to easy to slip up.  Even if you create a 'read only' prod account, still dangerous.

I would also be very surprised if your security/admin folks would allow this.

>>and you can also use RMAN Duplicate command check this doc for more details.

They already have the RMAN backup.  Duplicate would require a 'new' backup.  They just need to restore the existing backup on a new server.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Verification of DataPump Export and Import 17 60
Oracle 12c Default Isolation Level 17 41
Procedure syntax 5 39
date show only hh:mm 2 27
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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

860 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