You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
A.
The database must be running in archivelog mode.
B.
Flashback Database must be enabled.
C.
Fast Recovery Area must be enabled.
D.
The recyclebin must be enabled for the database.
E.
Undo retention guarantee must be enabled.
F.
A database backup must be taken.
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
A C
AC
AC.
Not B. If flashback database is not enabled, then the database must be mounted, not open, when creating the first guaranteed restore point (or if all previously created guaranteed restore points have been dropped).
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
AC.
A, C is here:
SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
NO
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Restore point created.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 113
Next log sequence to archive 115
Current log sequence 115
SQL>
AC
AC