[bbk4793] 第36集 - 第四章 Flashback Database 00

Objectives

After completing this lesson,you should be be able to :

  • Describe and use Oracle Total Recall
    • Creating and enabling a Flashback Data Archive(FDA)
    • Manageing FDAs
    • Viewing metadata
  • Describe and use flashback recycle bins
    • Restore dropped tables from the recycle bin
    • Manage space usage in the recycle bin
    • Query the recycle bin

Oracle Total Recall Overview

Automated tracking of historical database changes:

  • Enable at the table level with your specified retention period.
  • All subsequent changes are transparently stored and tamper proof.
  • Records older than retention period are automatically removed.
  • Use Flashback technologies to retrieve history.
SELECT ... AS OF TIMESTAMP

SELECT ... VERSIONS BETWEEN TIMESTAMP and TIMESTAMP

posted @ 2013-05-18 11:09  ArcerZhang  阅读(153)  评论(0编辑  收藏  举报