Steps to switchover from Primary Database to Standby Database in Oracle Dataguard

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

STEPS :

INFRA :

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;

INFRA_DG :

6. Alter database commit to switchover to primary;

7. shut immediate

8. startup

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

INFRA :

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