DATABASE SWITCHOVER ORACLE 19C USING DGMGRL
Description:
In this blog, we are going to see data guard switch over by using data guard broker DGMGRL.
Data Guard Switchover:
- A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss of data or resetting of redo logs. A switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss.
- This is typically done for planned maintenance of the primary system.
- During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.
- The transition occurs without having to re-enable either database.
Overall steps:
1. Connect the primary database with DGMGRL Data Guard broker. 2. Switch over primary to standby database. 3. Connect Standby database. 4. Switch over standby to primary.
Step 1: Connect the primary database with the DGMGRL Data Guard broker.
[oratest@oracle admin]$ dgmgrl sys/oracle@orcl DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Nov 12 13:19:44 2021 Version 19.9.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.Welcome to DGMGRL, type "help" for information. Connected to "orcl" Connected as SYSDBA.
Step 2: Switch over primary to the standby database.
DGMGRL> switchover to orcl_stby; Performing switchover NOW, please wait... Operation requires a connection to instance "orcl" on database "orcl_stby" Connecting to instance "orcl"... Connected as SYSDBA. New primary database "orcl_stby" is opening... Operation requires start up of instance "orcl" on database "orcl" Starting instance "orcl"...ORACLE instance started. Database mounted. Switchover succeeded, new primary is "orcl_stby" DGMGRL> Let's switch back to the original primary. Connect to the new primary (orcl_stby) and switchover to the new standby database (orcl).
Step 3: Connect the Standby database.
[oratest@oracle admin]$ dgmgrl sys/oracle@orcl_stby DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Nov 12 13:31:56 2021Version 19.9.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. Connected to "orcl_stby" Connected as SYSDBA.
Step 4: Switch over standby to primary
DGMGRL> switchover to orcl ; Performing switchover NOW, please wait... Operation requires a connection to instance "orcl" on database "orcl" Connecting to instance "orcl"... Connected as SYSDBA. New primary database "orcl" is opening... Operation requires start up of instance "orcl" on database "orcl_stby" Starting instance "orcl"... ORACLE instance started. Database mounted. Switchover succeeded, new primary is "orcl" DGMGRL>
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