ORA-39866
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.