OCP 1Z0 053 143

143.Which two are the prerequisites to enable Flashback Data Archive? (Choose two.) 
A. Database must be running in archivelog mode. 
B. Automatic undo management must be enabled. 
C. Undo retention guarantee must be enabled. 
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic 
Segment Space Management (ASSM). 
Answer: BD

http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#BJFFDCEH

Overview of Oracle Flashback Technology

Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

With flashback features, you can:

• Perform queries that return past data

• Perform queries that return metadata that shows a detailed history of changes to the database

• Recover tables or rows to a previous point in time

• Automatically track and archive transactional data changes

• Roll back a transaction and its dependent transactions while the database remains online

Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions. For example, if a user runs an UPDATE statement to change a salary from 1000 to 1100, then Oracle Database stores the value 1000 in the undo data.

ORA-55627: Flashback Archive tablespace must be ASSM tablespace

Cause: An attempt was made to add a tablespace that was not an ASSM tablespace.

Action: Add tablespace that is created with segment space management auto.