A Step-by-Step Flashback of RAC database to Restore Point

The following is the step-by-step process of Flashback of RAC database to a Restore Point.

1) Set the environment to correct instance.

ps -ef | grep pmon . oraenv

2) Get restore point name and make note of it from sqlplus.

SQL> select name, host_name, status from gv$instance; SQL> select log_mode,flashback_on from v$database; SQL> select name,time from v$restore_point;

3) Stop the database and put it in mount state using srvctl

srvctl status database -d MYTESTDB srvctl stop database -d MYTESTDB srvctl status database -d MYTESTDB srvctl start instance -d MYTESTDB -i MYTESTDB1 -o mount

4) Flashback to restore point using sqlplus

SQL> select instance_name,status from gv$instance; SQL> flashback database to restore point REST_POINT; SQL> alter database open resetlogs; Database altered.

5) Stop and start the database and make sure all instances are up, using srvctl.

srvctl stop database -d MYTESTDB srvctl start database -d MYTESTDB srvctl status database -d MYTESTDB I hope this is helpful!

Oracle Database Consulting Services

Ready to optimize your Oracle Database for the future?