Oracle Solution for Error ora-38793

ORA-38793: cannot FLASHBACK the database to a future SCN/time

What triggered the Error:

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

What should we do to fix it:

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