Database Error Messages

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

ORA-39876

cannot perform CDB OPEN RESETLOGS because data file string is in the middle of a PDB resetlogs operation

Cause

The data file mentioned was in the middle of a Pluggable Database (PDB) resetlogs operation.


Action

Recover the container database (CDB) to a different system change number (SCN) at which the data files are not in the middle of a PDB resetlogs operation. Alternatively, you can offline the problematic data file and let CDB OPEN RESETLOGS succeed. You may need to perform PDB point-in-time recovery later in order to open the PDB of the offlined data file.