My Oracle Support Banner

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

Last updated on JUNE 17, 2021

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.


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

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...
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> 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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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