Configuring Oracle Data Guard on Oracle Database Appliance

Depending on the version of the primary database, different methods can be used for setting up the Data Guard Physical Standby Database environment.

• Configuring Oracle Data Guard on Oracle Database Appliance Release 19.14 and Later Depending on the version of the primary database, use different methods for setting up the Oracle Data Guard physical standby database environment.

• Configuring Oracle Data Guard on Oracle Database Appliance Release 19.13 and Earlier

  Use Oracle RMAN to configure Oracle Data Guard on Oracle Database Appliance release 19.13 and earlier.

Configuring Oracle Data Guard on Oracle Database Appliance Release 19.14 and Later

Depending on the version of the primary database, use different methods for setting up the Oracle Data Guard physical standby database environment.

Guidelines for configuring Oracle Data Guard on Oracle Database Appliance release 19.14 and later:

• Oracle recommends running the primary and the standby databases on separate Oracle Database Appliance hardware, so ensure that you have at least two separate Oracle Database Appliance systems.

• Oracle recommends that the primary and standby systems have the same Oracle Database Appliance configuration, if possible. The databases must have a similar configuration for database shape, version, memory, networking, and storage (both must have either Oracle ASM or Oracle ACFS storage) to avoid unpredictability with the database switch roles.

• The primary and standby systems must be the same Oracle Database Appliance release, and must be on Oracle Database Appliance release 19.14 or later. Although the supported minimum release is Oracle Database Appliance release 19.14, due to critical bug fixes, it is strongly recommended that you upgrade your deployment to the latest Oracle Database Appliance release.

• If you have customized the operating system, then ensure that environments on both machines are identical.

• Ensure that your deployment follows Oracle Maximum Availability Architecture (MAA) best practices. See the Oracle Maximum Availability Architecture (MAA) page on Oracle Technology Network.

• If you decide to use Oracle ObjectStore for backup and recovery, then you must configure access for both the primary and standby systems.

This technical brief provides guidance for configuring Oracle Data Guard on bare metal systems. With two similarly configured bare-metal Oracle Database Appliance systems acting as primary and standby, and both running Oracle Database Appliance 19.14 or later, the recommended way to configure Oracle Data Guard is to use the built-in Oracle Database Appliance commands to manage the entire lifecycle of an Oracle Data Guard configuration in an easy and efficient way, including database upgrade and patching. Check the requirements for Integrated Oracle Data Guard with Oracle Database Appliance 19.14 for any limitation that may apply.

Oracle Database Appliance documentation library is available at:

https://docs.oracle.com/en/engineered-systems/oracle-database-appliance/index.html

Configuring Oracle Data Guard on Oracle Database Appliance Release 19.13 and Earlier

Use Oracle RMAN to configure Oracle Data Guard on Oracle Database Appliance release 19.13 and earlier.

Use the RMAN restore from service method if the database version is 12.1.0.2 or later. Refer to My Oracle Support Note 2283978.1 for details on how to instantiate the standby database using the restore… from service method. The RMAN restore… from service clause enables online restore and recover of primary database files to a standby database over a network. This method also allows for utilizing the SECTION SIZE clause for parallelization of the restore over multiple RMAN channels.

This document provides an example step-by-step procedure for creating a primary-standby configuration for Oracle 19c and 12c databases using Oracle Database Appliance.

When you set up your primary and standby database environments in an Oracle Data Guard configuration, adhere to the following guidelines that are specific to the Oracle Database Appliance platform.

• Oracle Enterprise Manager is not integrated with Oracle Database Appliance for instantiating a standby system. You can follow the examples provided in this document for configuring your Oracle Database Appliance 12c, 18c, or 19c environments.

• On the DCS stack, create the storage structure for your standby database with the odacli create-dbstorage command. For example:

  Oracle Database storage on Oracle ASM:

  # odacli create-dbstorage -n boston -u chicago

  Oracle Database storage on Oracle ACFS:

  # odacli create-dbstorage -n boston -u chicago -r ACFS