Rollback to restore point in Dataguard environment - RAC database

Step : Create Restore point and start Testing

-- In DR database
DGMGRL> show database crmdr;
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;
DGMGRL> edit database crmdr set state = 'APPLY-ON';

-- in Prod database
SQL> CREATE RESTORE POINT load_test GUARANTEE FLASHBACK DATABASE;

Step : Rollback after Testing done

-- Rollback -- In Prod database
$ srvctl stop   database -d crmprd
$ srvctl start  instance -d crmprd -i crmprd1 -o mount
SQL> flashback database to restore point load_test;
SQL> alter database open resetlogs;
$ srvctl stop   database -d crmprd
$ srvctl start  database -d crmprd

-- Rollback -- In DR database
DGMGRL> edit database crmdr set state = 'APPLY-OFF';
SQL> flashback database to restore point load_test;
DGMGRL> edit database crmdr set state = 'APPLY-ON';