Tuesday 19 June 2012

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

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.

No comments:

Post a Comment