Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Refresh oracle 10g database from Production to Test

Posted on 2009-07-15
2
Medium Priority
?
1,075 Views
Last Modified: 2013-12-19
I have an Oracle 10g production database on one server and a test database on another server. Both databases are identical in structure and patchset, the only difference is the production datafiles are on G drive on the live server and the test database datafiles are on D drive of the test server. Both databases are in noarchivelog mode and I have cold backups of the production database (backed up using RMAN) and also an OS copy. I would like a simple quick method of refreshing test with the live database as I will need to do this on a regular basis. I have read articles that say you can use RMAN to duplicate the database but none give any details. My oracle skills are unfortunately limited, so if anyone can provide an idiots guide I would very much appreciate it.
0
Comment
Question by:jonathanallen
[X]
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
2 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24864668
You can certainly use RMAN for this. Sorry I don't have an "idiot's guide" as you asked for but I can tell you the steps.

1) Its easiest if you have a common path on both machines (such as D:\STAGE)
2) Do RMAN backup on PROD to the D:\STAGE
3) Copy all files created in D:\STAGE to the DEV box and place under D:\STAGE
4) On DEV set these params:
alter system set db_file_name_convert = 'C:\oracle\prod\', 'C:\oracle\dev\' scope=spfile;
alter system set log_file_name_convert = 'C:\orace\prod\', 'C:\oracle\dev\' scope=spfile;
5) Startup dev nomount
6) Run RMAN on the DEV box, but connecting to the PROD service via TNS remotely, with DEV as auxiliary (DEV should be in nomount mode)
    rman target / auxiliary sys/admin@dev

7) RMAN> duplicate target database to dev dorecover;

Something like that. At that point the database should be in mount state and recovered with the archive logs from the backup.

Thats about as much as I can give you in this forum. I don't recommend it for an inexperienced Oracle DBA, but you sound willing. :)

0
 

Author Comment

by:jonathanallen
ID: 24867122
Many thanks for your help.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
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 video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

610 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