In previous article, we saw the creation of Oracle RAC on Oracle Cloud Infrastructure (OCI)

Installation 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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.