In this blog we will see how to switchover your Primary database to a Standby database and vice versa in a Oracle Dataguard Environment

For more exciting blogs on Oracle, please click the LINK

Let us take the Primary and Standby Databases as follows :

Primary DB : INFRA
Standby DB : INFRA_DG



1. Alter database commit to switchover to standby;

2. Shut immediate (If DB isnt shutdown automatically)

3. startup nomount

4. alter database mount standby database;

5. select name,open_mode,database_role from v$database;


6. Alter database commit to switchover to primary;

7. shut immediate

8. startup

9. select name,open_mode,database_role from v$database;


10. Alter database recover managed standby database disconnect from session;