Data Guard Manual Reinstate Using Flashback
Description:
In this blog, we are going to see step by step manual data guard reinstate process using the flashback database method.
Data Guard Reinstate:
After done failover to your Standby database so it becomes the new Primary. the old primary database can be reinstated as a standby database. this convert happens only in the database in flashback mode.
Overall Steps:
- Check the flashback enabled.
- Get the SCN number from the new primary database.
- Bounce the old primary database open in the mount stage.
- Flashback the database in SCN number of the new primary database.
- Convert the database to physical standby.
- Bounce the database and check the database role.
Step 1:- Check the flashback enabled after failover.
SELECT FLASHBACK_ON FROM V$DATABASE;
Step 2:- Get SCN number from the new primary database.
SQL> select to_char(standby_became_primary_scn) from v$database;
Step 3:- Bounce the Old primary database and open as mount stage.
SQL> shut immediate
SQL> startup nomount;
SQL> alter database mount;
Database altered.
Step 4:- Flashback the database in SCN number of the new primary database.
flashback database to scn 2370985;
flashback complete.
Step 5:- Convert the database to physical standby.
SQL> Alter Database Convert To Physical Standby;
Database altered.
Step 6:- Bounce the database and check the database role.
SQL> shut immediate
SQL> startup
ORACLE instance started.
Database mounted.
Database opened.
SQL> select name,open_mode,database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
SYSTEM READ ONLY PHYSICAL STANDBY
*******************************************************************************
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8