Oracle Solution for Error ora-38796

ORA-38796: Not enough flashback database log data to undo FLASHBACK.

What triggered the Error:

There was not enough flashback log data to undo the flashback so a flashback was not started.

What should we do to fix it:

It is still possible to get to the restore target by doing a flashback until the resetlogs branch point of the restore target is reached. This can be done by executing multiple "flashback to before resetlogs" commands, or by doing a flashback to the exact time or SCN of the desired resetlogs branch point. Note that this flashback cannot be undone should an error occur. The only option is to complete the flashback.