My Oracle Support Banner

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

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.0.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 22-May-2013***


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

On RMAN prompt transport tablespace command will fail with following error.

I) If Single data file created in source database:

    RMAN-03002: failure of transport tablespace command at 12/16/2008 18:06:09
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-06136: ORACLE error from auxiliary database: ORA-01245: offline file 7 will be lost if RESETLOGS is done
    ORA-01111: name for data file 7 is unknown - rename to correct file
    ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/PATH/UNNAMED00007'

II) If multiple data files created after full backup of database then TSPITR fails with following error:

    ORA-01422: exact fetch returns more than requested number of rows
    RMAN-20505: create datafile during recovery
    RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/tmp/FILE_NAME.dbf'
    ORA-00283: recovery session canceled due to errors
    ORA-01244: unnamed datafile(s) added to control file by media recovery
    ORA-01110: data file 8: '/u01/oradata/PATH/FILE_NAME.dbf'

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