Forum Stats

  • 3,815,638 Users
  • 2,259,064 Discussions
  • 7,893,194 Comments

Discussions

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