I was trying to do a duplicate database with the same SID to another hostname. Then, during my action I got the error “RMAN-05001: auxiliary “filename” conflicts with a file used by the target database”. To solve this problem I added the sintax “NOFILENAMECHECK” after the “duplicate target database to” command.
Below, it is showed the script that I used:
run {
# Perform allocate channel
allocate auxiliary channel t1 type ‘sbt_tape’
parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
allocate auxiliary channel t2 type ‘sbt_tape’
parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
allocate auxiliary channel t3 type ‘sbt_tape’
parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
set until time “to_date(’16 08 2015 20:00:00′,’DD MM YYYY HH24:MI:SS’)”;
# Perform duplicate database
duplicate target database to “ORCL” NOFILENAMECHECK
LOGFILE
GROUP 1
(‘/oracle/ORCL/origlogA/log_g11m1.dbf’,
‘/oracle/ORCL/mirrlogA/log_g11m2.dbf’,
‘/oracle/ORCL/mirrlogA/log_g1m2.dbf’) size 1000M reuse,
GROUP 2
(‘/oracle/ORCL/origlogB/log_g12m1.dbf’,
‘/oracle/ORCL/mirrlogB/log_g12m2.dbf’,
‘/oracle/ORCL/mirrlogB/log_g2m2.dbf’) size 1000M reuse,
GROUP 3
(‘/oracle/ORCL/origlogA/log_g13m1.dbf’,
‘/oracle/ORCL/mirrlogA/log_g13m2.dbf’,
‘/oracle/ORCL/mirrlogA/log_g3m2.dbf’) size 1000M reuse,
GROUP 4
(‘/oracle/ORCL/origlogB/log_g14m1.dbf’,
‘/oracle/ORCL/origlogB/log_g14m2.dbf’,
‘/oracle/ORCL/mirrlogB/log_g4m2.dbf’) size 1000M reuse,
GROUP 5
(‘/oracle/ORCL/origlogA/log_g15m1.dbf’,
‘/oracle/ORCL/mirrlogA/log_g15m2.dbf’) size 1000M reuse,
GROUP 6
(‘/oracle/ORCL/origlogB/log_g16m1.dbf’,
‘/oracle/ORCL/mirrlogB/log_g16m2.dbf’) size 1000M reuse;
release channel t1;
release channel t2;
release channel t3;
}
References:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta020.htm
