Solved

Refresh oracle 10g database from Production to Test

Posted on 2009-07-15
2
1,036 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
2 Comments
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 125 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

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.

Join & Write a Comment

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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…
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.

760 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

21 Experts available now in Live!

Get 1:1 Help Now