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 188.8.131.52.0 - Production on Fri Feb 28 02:55:28 2020 Version 184.108.40.206.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
- 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