|
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 （编辑：湖南网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
