Database Error Messages

OCI-39889

Specified System Change Number (SCN) or timestamp is in the middle of a previous PDB RESETLOGS operation.

Cause

The specified System Change Number (SCN) or timestamp was in the middle of a previous PDB RESETLOGS operation. More specifically, each PDB RESETLOGS operation may create a PDB incarnation as shown in v$pdb_incarnation. Any SCN between INCARNATION_SCN and END_RESETLOGS_SCN or any timestamp between INCARNATION_TIME and END_RESETLOGS_TIME as shown in v$pdb_incarnation is considered in the middle of the PDB RESETLOGS operation.


Action

Flashback the PDB to an SCN or timestamp that is not in the middle of a previous PDB RESETLOGS operation. If flashback to a SCN on the orphan PDB incarnation is required, then use "RESET PLUGGABLE DATABASE TO INCARNATION" RMAN command to specify the pluggable database incarnation along which flashback to the specified SCN must be performed. Also, ensure that the feature is enabled.