<div>
Many thanks for your help. 
</div>


<div>
<div class="content wysiwyg-content">
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.
</div>
</div>


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.

Refresh oracle 10g database from Production to Test

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.