Rollback database in RAC using guranteed restorepoint(GRP)

A. Create guaranteed restore point in testqa database.

Database name : TESTQA,

Instances: TESTQA1,TESTQA2

SQL>create restore point RESTORE_TESTQA guarantee flashback database;

B. Restore database using GRP. 

1. srvctl stop database -d testqa -o immediate
2. srvctl start database -d testqa -o mount
3. SQL>flashback database to restore point RESTORE_TESTQA; --using sqlplus
4. If error about missing redo logs, restore archivelogs using RMAN
5. srvctl stop database -d testqa
6. srvctl start instance -d testqa -i testqa1 -o mount
7. SQL> alter database open resetlogs; --using sqlplus
8. srvctl start instance -d testqa -i testqa2
9. srvctl stop database -d testqa -o immediate
10. srvctl start database -d testqa
11. SQL> drop restore point RESTORE_TESTQA; --using sqlplus