What two are the prerequisites for enabling Flashback Database? (Choose two)
A.
The database must be in ARCHIVELOG mode
B.
The database must be in MOUNT EXCLUSIVE mode
C.
The database must be opened in RESTRICTED mode
D.
The database instance must be started in the NOMOUNT state
E.
The database instance must have the keep buffer pool defined
Only A is correct. with Oracle 11g R2 you don’t have to need mount to database in order to enabling flashback database
I agree
You can enable flashback with “alter database flashback on” with the database open
This is a trick question, A and B are technically correct, but only between two diff versions of flashback database:
Reason for A (11g):
https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm
RMAN must be connected as TARGET to a database, which must be Oracle Database 10g or later. The target database must be mounted with a current control file, that is, the control file cannot be a backup or re-created. The database must run in ARCHIVELOG mode.
Reason for B (10g):
https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_9011.htm
Prerequisites
You must have the SYSDBA system privilege. A flash recovery area must have been prepared for the database, and the database must have been put in FLASHBACK mode with an ALTER DATABASE FLASHBACK ON statement. The database must be mounted in exclusive mode but not open.