To view how to configure Data Guard in OCI please check
Assumptions: Oracle Data Guard is configured in OCI and it is up, running and synchronized.
You can check the dgmgrl configuration before starting switchover by login to the server using Public IP.
[oracle@skantdr1 ~]$ dgmgrl /
DGMGRL for Linux: Release 19.0.0.0.0 - Production on Fri Feb 28 02:55:28 2020
Version 19.5.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected to "SKANTORC_iad134"
Connected as SYSDG.
DGMGRL> show configuration
Configuration - SKANTORC_iad19m_SKANTORC_iad13
Protection Mode: MaxPerformance
Members:
SKANTORC_iad19m - Primary database
SKANTORC_iad134 - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 103 seconds ago)You can see SKANTORC_iad19m is in primary state and SKANTORC_iad134 is in a standby state.
Now in OCI console open Data Guard Association tab in the primary database. Click on that vertical ellipsis sign near Launched option.
You will see 3 options
- Switchover
- Copy Peer Database OCID
- Copy Peer System DBID
Click on switchover.
Next, you will be asked for the database admin password. Enter the password and click on OK.
You will see Database in updating state and in few mins database role will be switchover.
You can check dgmgrl setting to view successful switchover operation.
DGMGRL> SHOW CONFIGURATION;
Configuration - SKANTORC_iad19m_SKANTORC_iad13
Protection Mode: MaxPerformance
Members:
SKANTORC_iad134 - Primary database
SKANTORC_iad19m - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 65 seconds ago)
You can see SKANTORC_iad19m was on primary role before and now is in standby role.
In the next post, we can perform patching of RAC in OCI.
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:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
