■ Flashback Query does not undo anything. It is only a query
mechanism. You can take the output from a Flashback Query and
perform an undo yourself in many circumstances.
■ Flashback Query does not tell you what changed. LogMiner does
that.
■ Flashback Query can undo changes and can be very efficient if
you know the rows that need to be moved back in time. You can
use it to move a full table back in time, but this is very expensive if
the table is large since it involves a full table copy.
■ Flashback Query does not work through DDL operations that
modify columns, or drop or truncate tables.
■ LogMiner is very good for getting change history, but it gives you
changes in terms of deltas (insert, update, delete), not in terms of
the before and after image of a row. These can be difficult to deal
with in some applications.

闪回查询注意事项
1. 闪回查询不会回滚任何数据 , 他只是一种查询机制
2. 闪回查询不会告诉你数据库进行了哪些修改操作, LogMiner 可以
3. 当明确哪些行需要恢复 , 闪回查询非常有效
4. 闪回查询对 DDL 操作无效，例如对列进行修改，删除清除表
5. LogMiner能很好的获取对数据库修改的历史记录

[@more@]

ITPub博客

Note Of Flashback Query (369)

最新文章