You want to create a guaranteed restore point for your …

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.

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



Leave a Reply 1

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