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 recycle bin must be enabled for the database.
E.
Undo retention guarantee must be enabled.
F.
A database backup must be taken.
A&C
AC
A,C
if database is not running in archivelog mode
ERROR at line 1:
ORA-38784: Cannot create restore point ‘dbrsp1’.
ORA-38785: Media recovery must be enabled for guaranteed restore point.
if Fast Recovery Area is not enabled
ERROR at line 1:
ORA-38784: Cannot create restore point ‘dbrsp1’.
ORA-38786: Recovery area is not enabled.
Mohamed Amin
[email protected]
AC