db version 19.12.0.0.0
OS: Linux X86-64
source CDB: PRDCDB ----- source PDB: PDB1
auxiliary target CDB: DEVCDB
we have a production container DB with 3 pdbs. we're looking to restore only 1 PDB from RMAN backup into a different server. below is the command i'm using below command from the oracle metalink "Cloning a Pluggable Database from an RMAN Container Database Backup (Doc ID 2042607.1)"
"duplicate database to DEVCDB pluggable database PDB1, root backup location '/backup/prdcdb_bkp/';"
when i use the above command the pluggable database gets refreshed fine, but the datafiles are being written to the ASM diskgroup name generated by the oracle like '+DATA01/PRDCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE'. But i want to have the datafiles to be restored into a diskgroup of my choosing like '+DATA01/DEVPDB'. so i am using the below command.
"duplicate database to DEVCDB pluggable database PDB1, root backup location '/backup/prdcdb_bkp/' DB_FILE_NAME_CONVERT=('+DATA01/PRDCDB/','+DATA01/DEVPDB/');"
when i use the above command i'm getting the below error.
RMAN-05001: auxiliary file name +DATA01/PRDCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.259.1074199967 conflicts with a file used by the target database
RMAN-05001: auxiliary file name +DATA01/PRDCDB/DATAFILE/users.265.1074199481 conflicts with a file used by the target database
RMAN-05001: auxiliary file name +DATA01/PRDCDB/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.266.1074199967 conflicts with a file used by the target database
I believe the errors are for the pdb$root of the source database. i don't care where the source pdb$root datafiles end up, but i want the source pdb datafiles to be restored in my user generated diskgroup like '+DATA01/DEVPDB'
is there any syntax error in my db_file_name_convert? any advice will be very helpful
Thank You