Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using RMAN DUPLICATE to clone Prod to Test in a different server

Tesla_5Aug 28 2014 — edited Aug 29 2014

DB version : 11.2.0.4 in 3-Node RAC

Platform : Oracle Linux 6.5

We have a 4TB DB which we want to clone for application team's testing. We want to use RMAN DUPLICATE for this.

We want to do a backup based duplication in a different server (another RAC cluster actually)

I have 2 questions

1. Potential danger of overwrite/other dangerous scenarios

------------------------------------

I've heard of dangerous incidents of RMAN accidently restoring (overwriting) data files to the production (target) data Diskgroup !!!

To prevent this, we are going to create diskgroup with a different name at auxiliary side.

This is a very critical production DB and we don't any harm to production DB due to this DUPLICATE activity.

Are are there any other things which can we do to avoid any mishaps ?

2. Recovery Catalog Connection

--------------------

None of our production DBs use catalog schema as the backup metadata repository. Control file in the respective DBs are used as the catalog.

Just to be on the safe side I want to run the DUPLICATE command from auxiliary (clone) server.

Is the below script enough ?

### At the auxiliary DB server. Running DUPLICATE command without catalog schema connection

rman target sys/mypass@PROD_DB  auxiliary /

run

SET UNTIL time 'sysdate-10/24';

{

allocate auxiliary channel c1 device type disk;

allocate auxiliary channel c2 device type disk;

allocate auxiliary channel c3 device type disk;

duplicate target database to UAT_DB;

}

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2014
Added on Aug 28 2014
7 comments
2,941 views