Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.7K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
duplicate a single pdb into a different server using rman backups

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