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
