ORA-00376 For Unneeded Datafile During RMAN TSPITR

(Doc ID 1458407.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

o Starting a fully automated RMAN TSPITR, but when coming to the part where rman initiates an EXPDP
  to export metadata from the clone, it tries to read from a file that is part of the
  target database, but not part of the recovery set, and it fails with
     
     "ORA-00376: file 4 cannot be read at this time".
   
  All database level triggers have been disabled but error persists:

Performing export of metadata...
 EXPDP> Starting "SYS"."TSPITR_EXP_dpdA":
 EXPDP> ORA-39123: Data Pump transportable tablespace job aborted
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: '/dbo/STEFTST/data2/STEFTST_tools_000.dbf'
---
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/07/2012 13:45:54
RMAN-06962: Error received during export of metadata
RMAN-06965: Datapump job has stopped
RMAN-06960:    EXPDP> Job "SYS"."TSPITR_EXP_dpdA" stopped due to fatal error at 13:45:39



# Deinstalling xdb allowed the tspitr operation to complete successfully
# Re-installing xdb into the default tablespace (sysaux) also allowed the tspitr operation to complete successfully
# So problem appears to be that if XDB is installed anywhere, other than the default tablespace it causes tspitr to fail

 

o If XDB Tablespace is NOT SYSAUX
  -> If including XDB Tablespace in TSPITR recovery set, you will get error on rollback segment

....
Performing export of metadata...
EXPDP> Starting "SYS"."TSPITR_EXP_lvyF":
EXPDP> ORA-39123: Data Pump transportable tablespace job aborted
ORA-01552: cannot use system rollback segment for non-system tablespace 'XDB'

This is Fixed by moving XDB schema to SYSAUX

SQL> exec dbms_xdb.MOVEXDB_TABLESPACE('SYSAUX');

Reference: (Doc ID 1271560.1) 

Changes

 XDB was installed in datafile 4 instead of the default sysaux tablespace

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms