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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-38796：没有足够的闪回数据库日志数据来撤消FLASHBACK。,
.原因：没有足够的闪回日志数据来撤消闪回，因此闪回未启动。,
.操作：它仍然是可以通过达到恢复目标的重置日志分支点，直到做了闪去的恢复目标。这可以通过命令，或者做一个倒叙到所需的重置日志分支点的确切时间或SCN执行多个“前RESETLOGS闪回”来完成。请注意，如果发生错误，则无法撤消此闪回。唯一的选择是完成闪回。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题