Oracle Error ORA-38791: flashback did not start because file string was not in a valid incarnation

Oracle Error Message

ORA-38791: flashback did not start because file string was not in a valid incarnation

Reason for the Error

Flashback could not be started because a file was checkpointed or fuzzy at a point where the file can neither be restored nor recovered to our restore target. In order for a file to be brought to the restore target, the file has to be in one of the incarnations along the ancestral path from the current incarnation to the restore incarnation.

Solution

Manually restore or recover the file to a point where it is in one of the incarnations along the ancestral path from the current incarnation to the restore incarnation.