[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