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;
}