Database Error Messages

ORA-38796

Not enough flashback database log data to undo FLASHBACK.

Cause

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


Action

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.