In previous article, we saw the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI)
In this post, we will see how to configure data guard with RAC on OCI.
- Assumption : Oracle RAC database is already installed and configured on OCI.
- Click on Displa Name: DBSVM
- Click on Databases on Resources in left side pane. Then click on Database Name – SKANTORC
- Click on Data Guard Association on Resources in left side pane. Then click on Enable Data Guard button.
As shown in the below image. Provide all the information.
- Display Name : SKANTDRVM
- Availability Domain : aXWk:US-ASHBURN-AD-1
- Shape : VM.Standard2.2
- Client Subnet : Public Subnet-SKANTVCN(regional)
- Hostname Prefix : SKANTDR
- Protection Mode is Maximum Performance by default
- Transport type is ASYNC.
- Provide admin password
- Click on Enable Data Guard.
After sometimes, data guard has been created.
- Click on the Display Name for Data Guard: SKANTDRVM
Now, use the private key and public IP of any node and connect to server with OPC user for getting the more details.
login as: opc
Authenticating with public key "rsa-key-20200220"
[opc@skantdr1 ~]$ sudo su - oracle
Last login: Fri Feb 28 02:51:45 UTC 2020
[oracle@skantdr1 ~]$ ps -ef|grep pmon
oracle 12510 1 0 Feb27 ? 00:00:02 ora_pmon_SKANTORC1
grid 71169 1 0 Feb27 ? 00:00:02 asm_pmon_+ASM1
grid 80533 1 0 Feb27 ? 00:00:01 apx_pmon_+APX1
oracle 99783 99546 0 02:53 pts/0 00:00:00 grep --color=auto pmon
[oracle@skantdr1 ~]$ sqlplus / as sysdba
Connected to:
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
SQL> select NAME,INSTANCE_NAME,HOST_NAME,OPEN_MODE,LOG_MODE,DATABASE_ROLE,CREATED from gv$database d ,gv$instance i where d.inst_id=i.inst_id;
SQL> set lines 200 pages 200
NAME INSTANCE_NAME HOST_NAME OPEN_MODE LOG_MODE DATABASE_ROLE CREATED
--------- ---------------- ---------------------------------------------------------------- -------------------- ------------ ---------------- ---------
SKANTORC SKANTORC1 skantdr1 READ ONLY WITH APPLY ARCHIVELOG PHYSICAL STANDBY 27-FEB-20
SKANTORC SKANTORC2 skantdr2 READ ONLY WITH APPLY ARCHIVELOG PHYSICAL STANDBY 27-FEB-20
SQL> exit
Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
[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)
DGMGRL> exit
In the next post, we will perform switchover in Data Gaurd for this RAC setup on 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
