Oracle - Create restore points in Data Guard environment

*************** On Standby


SQL> select db_unique_name, database_role, open_mode, flashback_on,dataguard_broker, guard_status, protection_mode from v$database;

SQL> alter database recover managed standby database cancel;

SQL> create restore point RP1 guarantee flashback database;

SQL> alter database recover managed standby database using current logfile disconnect;

SQL> select * from v$restore_point;


************ On Primary

SQL> select db_unique_name, database_role, open_mode, flashback_on,dataguard_broker, guard_status, protection_mode from v$database;

SQL> create restore point RP1 guarantee flashback database;

SQL> select * from v$restore_point;