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!
Share this
Next story
Using ProxySQL to validate MySQL updates →
You May Also Like
These Related Stories
Step-by-step guide to January 2016 PSU patch apply on 12c drid and RDBMS homes in Linux
Step-by-step guide to January 2016 PSU patch apply on 12c drid and RDBMS homes in Linux
Feb 12, 2016
3
min read
Simple steps to perform opatch maintenance with Ansible
Simple steps to perform opatch maintenance with Ansible
Apr 24, 2017
7
min read
Avoid Boiling the Ocean: Taking Baby Steps Towards a Data Quality Strategy
![](https://www.pythian.com/hubfs/Avoid%20Boiling%20the%20Ocean-jpeg.jpeg)
Avoid Boiling the Ocean: Taking Baby Steps Towards a Data Quality Strategy
Jun 24, 2024
5
min read
No Comments Yet
Let us know what you think