FDA is used for auditing purpose and we need to create a separate tablespace for it.
FDA uses point in time recovery to recover the data where as Flashback Technology uses the flashback archive logs to recover and restore the data.
oracle@venu1>export ORACLE_SID=venu1
oracle@venu1>sqlplus / as sysdba
sys>startup
sys>select name,open_mode,log_mode from v$database;
sys>select instance_name,status from v$instance;
sys>select name from v$datafile;
sys>select name from v$controlfile;
sys>select member from v$logfile;
sys>select name from v$tablespace;
sys>create tablespace fra_ts datafile '/u01/app/oracle/venu/fda_ts01.dbf' size 10m autoextend on;
sys>create flashback archive fda_1yr tablespace fda_ts retension 1year;
sys>desc dba_flashback_archive;
sys>select * from dba_flashback_archive;
sys>conn scott/tiger
scott>select * from tab;
scott>alter table salgrade flashback archive fda_1yr;
scott>conn / as sysdba
sys>grant flashback archive on fda_1yr to scott;
sys>conn scott/tiger
scott>alter table salgrade flashback archive fda_1yr;
scott>desc user_flashback_archive_tables;
scott>select * from user_flashback_archive_tables;
scott>select sysdate from dual;
scott>set time on;
scott>select * from salgrade;
scott>delete from salgrade where grade=1;
scott>commit;
scott>select * from salgrade;
scott>select * from salgrade as of timestamp to_timestamp('25-MAY-2013 23:09:28','dd-mm-yyyy hh24:mi:ss');
scott>select * from tab;
scott>select * from SYS_FBA_HIST_12345;
scott>select * from salgrade;
scott>insert into salgrade select * from salgrade as of timestamp to_timestamp('25-MAY-2013 23:09:28','dd-mm-yyyy hh24:mi:ss');
scott>set time off;
scott>alter table salgrade no flashback archive;
scott>grant flashback archive administer to scott;
scott>alter table salgrade no flashback archive;
