My Oracle Support Banner

Transport Tablespace Failed With Error RMAN-11003/ORA-01111/ORA-01244 (Doc ID 756440.1)

Last updated on JANUARY 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.0.1 to 11.1]
Information in this document applies to any platform.


-- Problem Statement:
When attempt to create transport tablespace set using RMAN backupset, if new data files were created in source database after complete backup.  Auxiliary instance tablespace point in time recovery (TSPITR) fails with following error.

-- Steps To Reproduce:

  1. Perform complete database backup using RMAN.
  2. Add new data files to tablespaces after completion of full backup.
  3. Verify the transport tablespace is self-contained or not using dbms_TTS package.
  4. Execute command to create transportable set using rman.

RMAN> run {
  transport tablespace <Self-contained tablespace name step 3>
  auxiliary destination '/oracle/product/10.2.0/PATH/aux'
  tablespace destination '/oracle/product/10.2.0/PATH/aux';


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.