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!
I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.
