Solved

Refresh oracle 10g database from Production to Test

Posted on 2009-07-15
2
1,041 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Getting TNS:Connect timeout occurred while opening the application 5 57
dates - loop 12 57
Query Records that don't match 8 34
MULTIPLE DATE QUERY 15 49
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

910 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

24 Experts available now in Live!

Get 1:1 Help Now