Database Error Messages

ORA-39866

Data files for Pluggable Database string must be offline to flashback across special 12.1 PDB resetlogs.

Cause

An attempt was made to perform a FLASHBACK DATABASE beyond a Pluggable Database (PDB) resetlogs performed at 12.1 compatibility. Futhermore, the PDB resetlogs was performed after a flashback or point-in-time recovery (PITR) of the PDB to its parent database incarnation. This is not supported unless all data files in the PDB are offline.


Action

Take the data files for the Pluggable Database (PDB) offline before performing the FLASHBACK DATABASE command. To bring the PDB to the same past point in time as the container database (CDB), those data files can be restored from backups and recovered to that same past point in time. This can be done in one of two ways:

  • Flashback the CDB and open the CDB with resetlogs.

Restore the PDB later, and perform a complete PDB recovery.

  • Flashback the CDB first. Restore and recover the PDB to the

same system change number (SCN). Open CDB with resetlogs.