Flashback Data Archive

 

• FDA was introduced in Oracle 11g to allow you to protect UNDO information, allowing guaranteed flashback queries.

• FDA simply give you a view of how the data was in the past, which in turn can be used to recover from logical corruption, such as accidental deletions. 

•  FDA relies on how long undo information is retained, as specified by the UNDO_RETENTION parameter. If UNDO is overwritten / flushed out you will not be able to query your data.

    

        Perform an Update and commit.

        update employee set emp_job_notes='test';

        commit;

        

        Use below query post commit, to see the state of data 15 mins before the commit,

        select * from employee as of timestamp (systimestamp - interval '15' minute);