Which two are prerequisites for setting up Flashback Data Archive?
A.
Fast Recovery Area should be defined.
B.
Undo retention guarantee should be enabled.
C.
Supplemental logging should be enabled.
D.
Automatic Undo Management should be enabled.
E.
All users using Flashback Data Archive should have unlimited quota on the Flashback
Data Archive tablespace.
F.
The tablespace in which the Flashback Data Archive is created should have Automatic
Segment Space Management (ASSM) enabled.
Explanation:
Reference:
http://www.oracle.com/technetwork/database/focus-areas/storage/total-recall-whitepaper-
171749.pdf (page 8)
D and F
D and F are correct
http://www.dba-oracle.com/t_11g_new_enabling_fdba.htm
Thanks Vonpire!
Again. Thanks Vonphire D, F.
There are a number of restrictions for flashback archives:
The tablespaces used for a flashback archive must use local extent management and automatic segment space management.
The database must use automatic undo management.
D,F
The QUOTA can be adjusted dynamically at any time by:
adding more tablespaces to the flashback archive or by
modifying the quota on a tablespace which is already part of the flashback archive:
DF
DF