ORA-00376 For Unneeded Datafile During RMAN TSPITR
(Doc ID 1458407.1)
Last updated on MARCH 09, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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:
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: '/<path>/<datafilename>.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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |