Database Error Messages

OCI-38793

cannot FLASHBACK the database or pluggable database to a future SCN or time

Cause

The Flashback Pluggable Database target SCN or timestamp is greater than the current database or pluggable database SCN/timestamp and the database or pluggable database incarnation is not the last opened incarnation.


Action

If the target SCN or timestamp is in the current incarnation or a child incarnation whose branch point is after the current database or pluggable database SCN then RECOVER DATABASE or RECOVER PLUGGABLE DATABASE to the target SCN or time. If the target SCN or timestamp is in a child incarnation whose branch point is prior to the current database or pluggable database SCN then FLASHBACK DATABASE to before the branch point. Next, use RMAN to reset the database or pluggable database to the child incarnation. Finally, RECOVER DATABASE OR PLUGGABLE DATABASE to the target SCN time.