Below are the steps for flashback a database to restore point in a RAC database.

1. Check the restore point details.

 SELECT NAME FROM V$RESTORE_POINT;

NAME 
------------
STAGE_CR178 

2. Check the status of the database.

srvctl status database -d DBPRE
Instance DBPRE1 is running on node dbats-2
Instance DBPRE2 is running on node dbats-2



SQL> select instance_name,status from gv$Instance;

INSTANCE_NAME    STATUS
---------------- ------------
DBPRE1          OPEN
DBPRE2          OPEN

For flashback database to restore point in RAC database, we need to mount the database only on one node and run the flashback command.

Below steps we will do only on node 1 .

3. Stop the database.[ node 1 ]

srvctl stop database -d DBPRE

4. Mount only one instance [ node 1 ]

srvctl start instane -d DBPRE -i DBPRE1 -o mount

5. Flashback the database. [ node 1 ]

flashback database to restore point STAGE_CR178;

6. Do resetlog [ node 1 ]

alter database open resetlogs;

7. Restart the database.[ node 1 ]

srvctl stop database -d DBPRE
srvctl start database -d DBPRE

We have successfully completed flashback for the RAC database.