Skip to main content

ORA-01516: nonexistent log file, data file, or temporary file "xxx" in the current container


Commvault Marcus
Vaulter
Forum|alt.badge.img+8

Restore and recover of a lost datafile in a PDB is failing with the following:

##### Exceuting Tablespace offline script for partial restore #####
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 27 13:48:24 2025
Version 19.18.0.0.0
Copyright (c) 1982, 2022, Oracle.  All rights reserved.
SQL>SQL>SQL>SQL>Connected.
SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>alter database datafile 105 offline
*
ERROR at line 1:
ORA-01516: nonexistent log file, data file, or temporary file "xxx" in the current container
SQL>  1* alter database datafile xxx offline
SQL>SQL>Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
##### End Exceuting Tablespace offline script #####

 

Solution:
Online and offline commands must be execute from the same container in which datafile resides as v$datafile and dba_data_files only have the entries of the datafiles belonging to that container.
 

  1. Connect to the PDB in question and bring the datafile offline
  2. Uncheck the option to Switch tablespace for restore
  3. run the restore
  4. Bring datafile online after the restore

 

2 replies

CV_GK
Vaulter
Forum|alt.badge.img+5
  • Vaulter
  • 71 replies
  • April 3, 2025

Hi ​@Commvault Marcus 

I see you mentioned Solution - did it work?


Commvault Marcus
Vaulter
Forum|alt.badge.img+8

Yes. the Solution is from an Oracle KB article.  KB105952


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings