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

Fahd Mirza
by Fahd Mirza
1 min read
Oct 21, 2016

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!
Previous story
← While upgrading to 12.1.0.2 I faced error ORA-01830 / ORA-06512
Next story
Using ProxySQL to validate MySQL updates →
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
A step-by-step look at MySQL returns results in a non-deterministic order.
MySQL

A step-by-step look at MySQL returns results in a non-deterministic order.

Feb 13, 2017 18 min read
Step-by-step upgrades to Cloudera Manager and CDH

Step-by-step upgrades to Cloudera Manager and CDH

Dec 4, 2015 6 min read

Get Email Notifications

No Comments Yet

Let us know what you think

Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.