Solved

Refresh oracle 10g database from Production to Test

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

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

839 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