Hi I want create a pluggable database from an RMAN backup into a new CDB.
From host1 I made a backup of the PDB ( Not in RAC and ASM architecture )
alter pluggable database TESTEXPORT close immediate;
RMAN> backup for transport
unplug into '/mnt/backup/SIMCORP/export_metadata.xml'
format '/mnt/backup/SIMCORP/export.bck'
pluggable database TESTEXPORT;
After that i copied '/mnt/backup/SIMCORP/export_metadata.xml' and '/mnt/backup/SIMCORP/export.bck' to the second host
Now I want restore in the second host CDB (2 nodes RAC with ASM ) the pdb.
When I run
RMAN> restore
using '/mnt/backup/SIMCORP/export_metadata.xml'
foreign pluggable database "TESTIMPORT2"
format '+DGDATA'
from backupset '/mnt/backup/SIMCORP/export.bck'
;2> 3> 4> 5> 6>
Starting restore at 29-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 instance=CDB11 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring all foreign files in backup piece
channel ORA_DISK_1: reading from backup piece /mnt/backup/SIMCORP/export.bck
channel ORA_DISK_1: restoring foreign file 400 to +DGDATA
channel ORA_DISK_1: restoring foreign file 401 to +DGDATA
channel ORA_DISK_1: foreign piece handle=/mnt/backup/SIMCORP/export.bck
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:22:36
channel ORA_DISK_1: plugging file 398 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_system_hjz1yts5_.dbf
channel ORA_DISK_1: plugging file 399 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sysaux_hjz1ytxy_.dbf
channel ORA_DISK_1: plugging file 400 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_undotbs1_hjz1yv3h_.dbf
channel ORA_DISK_1: plugging file 8 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_temp_hjz1yv7d_.dbf
channel ORA_DISK_1: plugging file 9 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_temp_hjz1yv8w_.dbf
channel ORA_DISK_1: plugging file 401 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_users_hjz1yvb4_.dbf
channel ORA_DISK_1: plugging file 402 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scusers_hjz1yvfw_.dbf
channel ORA_DISK_1: plugging file 403 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sysaud_hjz1yvkr_.dbf
channel ORA_DISK_1: plugging file 404 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scsys_hjz1yvoh_.dbf
channel ORA_DISK_1: plugging file 405 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sctrddat_hjz1yvsb_.dbf
channel ORA_DISK_1: plugging file 406 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sctrdidx_hjz1yvx0_.dbf
channel ORA_DISK_1: plugging file 407 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sctrdarc_hjz1yw1f_.dbf
channel ORA_DISK_1: plugging file 408 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scdat_hjz1yw55_.dbf
channel ORA_DISK_1: plugging file 409 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scindx_hjz1yw8v_.dbf
channel ORA_DISK_1: plugging file 410 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scaudit_hjz1ywdm_.dbf
channel ORA_DISK_1: plugging file 411 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scaudix_hjz1ywj9_.dbf
channel ORA_DISK_1: plugging file 412 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_sctrdque_hjz1ywn2_.dbf
channel ORA_DISK_1: plugging file 413 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scqueue_hjz1ywqv_.dbf
channel ORA_DISK_1: plugging file 414 for /u02/oradata/ANI1842A/AA81AC2133B32807E053071CC90AAEDD/datafile/o1_mf_scdwh_hjz1ywvy_.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/29/2020 15:47:06
RMAN-00600: internal error, arguments [5304] [+DGDATA] [] [] []
And in my CDB alert log i only have:
2020-07-29T15:24:32.140394+02:00
Full restore complete of datafile 401 to datafile copy +DGDATA/CDB1/AA81AC2133B32807E053071CC90AAEDD/DATAFILE/users.386.1047050671. Elapsed time: 0:00:01
checkpoint is 5970741450662
last deallocation scn is 3
2020-07-29T15:47:05.995150+02:00
Full restore complete of datafile 400 to datafile copy +DGDATA/CDB1/AA81AC2133B32807E053071CC90AAEDD/DATAFILE/undotbs1.338.1047050671. Elapsed time: 0:22:34
checkpoint is 5970741450662
last deallocation scn is 5866860363446
Undo Optimization current scn is 5866860362575
The 2 datafiles are in ASM.
What 's wrong?