678.Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)
A.Flash recovery area must be defined
B.Undo retention guarantee must be enabled.
C.Database must be running in archivelog mode.
D.Automatic undo management must be enabled.
E.The tablespace in which theFlashbackDataArchive is created must have automatic segment space
Management (ASSM).
Answer: DE
答案解析:
闪回数据归档参考:http://blog.csdn.net/rlhua/article/details/12221269
A,错误,闪回数据归档跟FRA区没有关系,闪回归档的数据是保存在闪回数据表空间的数据文件里。
B,错误,参考http://blog.csdn.net/rlhua/article/details/12222819,闪回数据归档和undo数据没关系。
C,错误,在非归档模式下也能创建闪回数据归档。
sys@TEST0924> select tablespace_name,segment_space_management from dba_tablespaces;
TABLESPACE_NAME SEGMEN ------------------------------ ------ SYSTEM MANUAL SYSAUX AUTO UNDOTBS1 MANUAL TEMP MANUAL USERS AUTO EXAMPLE AUTO TESTTBS AUTO TESTUNDOTBS MANUAL
8 rows selected.
sys@TEST0924> create flashback archive fla2 tablespace users quota 10M retention 1 year 2 sys@TEST0924> create flashback archive fla2 tablespace TESTUNDOTBS quota 10M retention 1 year; create flashback archive fla2 tablespace TESTUNDOTBS quota 10M retention 1 year * ERROR at line 1: ORA-55627: Flashback Archive tablespace must be ASSM tablespace