Using Flashback Technology II in Oracle || Admin II Chapter No 11 Part 1st

After completing this lesson, you should be able to:
Describe and use Oracle Total Recall
Creating and enabling a Flashback Data Archive (FDA)
Managing 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
The Oracle Total Recall option in Oracle Database 11g (also known as Flashback Data Archive) provides a mechanism for tracking changes to production databases that is secure, efficient, easy to use, and application transparent.
With Oracle Total Recall technology, you can automatically track and store the data in tables enabled for Flashback Data Archive. This ensures that flashback queries obtain SQL-level access to the versions of database objects without getting a snapshot-too-old error.
A Flashback Data Archive provides the ability to track and store all transactional changes to a “tracked” table over its life time. It is no longer necessary to build this intelligence into your application. You can use Oracle Total Recall for compliance, audit reports, data analysis, and decision-support systems. The Flashback Data Archive background process starts with the database.
Use case examples:
Audit support: Find duplicate insurance claims from the last year.
Compliance support: Monitor stock trading during a quiet period.
Information Lifecycle Management (ILM): Guarantee immutable access to patient history.
Retention policy enforcement: Automatically purge records older than five years.
Historical reporting: Retrieve a client’s credit and payment history.
Error Recovery: Restore records erroneously removed or updated.