Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Refreshing a development DB with production backup

Posted on 2011-03-23
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 77

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 77

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:
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

LVL 38

Accepted Solution

Geert Gruwez earned 2000 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

by:Praveen Kumar Chandrashekatr
ID: 35205400

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

Expert Comment

by:Praveen Kumar Chandrashekatr
ID: 35205410
and you can also use RMAN Duplicate command check this doc for more details.
LVL 77

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

704 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