数据库 – 是Oracle Total Recall的替代方案吗？

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