Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-39884

Flashback of PDB (con_id:string) cannot restore data file string which is currently used by PDB (con_id:string).

Cause

The data file required to flashback the specified pluggable database to the specified point in time could not be restored. The file number of the pluggable database data file was used by a different pluggable database.


Action

Flashback the pluggable database to a different point-in-time. Alternatively, drop the conflicting data file from the database first before you flashback the pluggable database. If neither option can be used, you can also flashback the entire consolidated database or restore and recover a copy of the consolidated database to the specified point-in-time. You can then extract the recovered data.