Oracle Total Recall是Oracle Enterprise Edition(11g)的一个选项,可提供对历史数据的安全保留和访问.
从白皮书:
Flashback Data Archive creates an internal history table for every tracked table. The internal history table is initially a replica of the FDA-enabled table with additional metadata columns. When one or more columns in the tracked table are updated,a new row is inserted into the history table that is the before-image of the row before the transaction. UPDATE and DELETE operations generate a new record in the history table,but INSERT operations do not – inserted rows appear in the base table. The internal history table is partitioned for better performance,and compressed to reduce disk space requirements. No modifications are allowed to internal history tables. Applications and users can use the ‘AS OF’ and ‘VERSIONS BETWEEN’ SQL constructs to seamlessly query the historical data.
是(开源)替代历史跟踪吗?
解决方法
您可以在大多数RDBMS中使用日志恢复,但它并不像Oracle那样“简单”.基本上,所有RDBMS都可以跟踪所有已执行的查询.
因此,您可以在单独的服务器上使用它来从完整备份重放执行的查询,并在任何给定的时间点恢复数据库的状态(即,您可以在事务xxx之后的12月3日13:53查看数据库的状态).您还可以分析日志并查看发生的情况.
这是非常有限的,不太实用.
在这里查看PostgreSQL文档:http://www.postgresql.org/docs/8.4/static/continuous-archiving.html (编辑:威海站长网)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|