Which two tasks should you perform before enabling Flashback Database?

Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?

A.
Enable minimal supplemental logging.

B.
Ensure that the db_flashback_retention_target parameter is set to a point in time (in
minutes) to which the database can be flashed back.

C.
Enable the recyclebin.

D.
Enable undo retention guarantee.

E.
Enable Fast Recovery Area.



Leave a Reply 9

Your email address will not be published. Required fields are marked *


vijay

vijay

Ans. B and E.

Mohamed

Mohamed

B and E
Ref: https://docs.oracle.com/database/121/BRADV/flashdb.htm#BRADV582
Section: About Flashback Database
Flashback Database uses its own logging mechanism, creating flashback logs and storing them in the fast recovery area. You can only use Flashback Database if flashback logs are available. To take advantage of this feature, you must set up your database in advance to create flashback logs.