RMAN Crossplatform error Restoring converted "backup For Transport" Backup Into Another Host (Doc ID 2293257.1)

Last updated on JUNE 17, 2021

Applies to:

Symptoms

Using the procedure to cross-platform transport tablespaces from HPUX database to windows

https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-rman-cross-plat-transp-tablespace.html

There are errors at step 6 (restore foreign files) and specifically at restoring the datapump dmp file and I'm getting this error

Performing import of metadata...
  IMPDP>
WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.

  IMPDP> Master table "SYS"."TSPITR_IMP_ORCL_zlFu" successfully loaded/unloaded
  IMPDP> Starting "SYS"."TSPITR_IMP_ORCL_zlFu":
  IMPDP> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
  IMPDP> ORA-39123: Data Pump transportable tablespace job aborted
ORA-29342: user <USER_NAME> does not exist in the database

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/14/2017 12:42:31
RMAN-06963: Error received during import of metadata
RMAN-06965: Datapump job has stopped
RMAN-06961: IMPDP> Job "SYS"."TSPITR_IMP_ORCL_zlFu" stopped due to fatal error at Fri Apr 14 12:42:28 2017 elapsed 0 00:00:03

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.