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.
flashbackRAC HOW TOORACLE RAC