1. Middleware Lifecycle Management Administrator's Guide
  2. Patching Software Deployments
  3. Applying Patches
  4. Patching Oracle Data Guard Targets
  5. Oracle Data Guard Patching Scenarios

Oracle Data Guard Patching Scenarios

This section describes the steps to patch your Oracle Data Guard targets in various scenarios.

Scenario 1: The primary and standby databases are RAC databases.

Table 14-2 describes the steps to apply an Oracle Grid Infrastructure PSU or an Oracle Database PSU, when the primary and standby databases are RAC databases:

Table 14-2 Oracle Data Guard Patching (RAC - RAC)

Primary and Standby Database Configuration How to Patch?
The primary and the standby RAC databases are running from the same cluster.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
The primary and the standby RAC databases are running from different clusters.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target that contains the standby RAC database.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. (Optional) Perform a database switchover, such that the standby RAC database becomes the new primary database, and vice versa.

    For information on how to perform a database switchover, see Overview of Switchover and Failover in a Broker Environment in Oracle Data Guard Broker.

  5. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the cluster target that contains the primary RAC database (or the new standby database, in case you have performed a switchover).
  6. Specify the required deployment options.
  7. Analyze and deploy the plan.
Two primary RAC databases, P1 and P2, are running from two different clusters, C1 and C2, respectively. Their standby RAC databases, S1 and S2, are running from C2 and C1, respectively.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the first cluster target (C1).
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the second cluster target (C2).
  5. Specify the required deployment options.
  6. Analyze and deploy the plan.

Note:

You can patch the clusters in any order, that is, C1 first and then C2, or C2 first and then C1.
Scenario 2: The primary database is a RAC database, and the standby database is a single-instance database that is managed by a Cluster Ready Services (CRS) target or a Single Instance High Availability (SIHA) target.

Table 14-3 describes the steps to apply an Oracle Grid Infrastructure PSU or an Oracle Database PSU, when the primary database is a RAC database, and the standby database is a single-instance database that is managed by a CRS target or a SIHA (Single Instance High Availability) target.

Table 14-3 Oracle Data Guard Patching (RAC - SIDB)

Primary and Standby Database Configuration How to Patch?
The primary RAC database and the standby single-instance database are running from the same cluster.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
The primary RAC database and the standby single-instance database are running from different clusters.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target that contains the standby single-instance database.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. (Optional) Perform a database switchover, such that the standby single-instance database becomes the new primary database, and vice versa.

    For information on how to perform a database switchover, see Overview of Switchover and Failover in a Broker Environment in Oracle Data Guard Broker.

  5. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the cluster target that contains the primary RAC database (or the new standby database, in case you have performed a switchover).
  6. Specify the required deployment options.
  7. Analyze and deploy the plan.
Two primary RAC databases, P1 and P2, are running from two different clusters, C1 and C2, respectively. Their standby single-instance databases, S1 and S2, are running from C2 and C1, respectively.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the first cluster target (C1).
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the second cluster target (C2).
  5. Specify the required deployment options.
  6. Analyze and deploy the plan.

Note:

You can patch the clusters in any order, that is, C1 first and then C2, or C2 first and then C1.

Scenario 3: The primary and standby databases are single-instance databases that are managed by CRS or SIHA targets.

Table 14-4 describes the steps to apply an Oracle Grid Infrastructure PSU or an Oracle Database PSU, when the primary and standby databases are single-instance databases that are managed by CRS or SIHA targets.

Note:

When patching Single Instance High Availability (SIHA)12.1.0.2 Oracle Database through Enterprise Manager 13.4 and Perl 5.38 Update, the database needs to be patched at least to version 12.1.0.2.191015, with the October 2019 or later GI PSU patch applied on the target.

Table 14-4 Oracle Data Guard Patching (SIDB - SIDB)

Primary and Standby Database Configuration How to Patch?
The primary and the standby single-instance databases are running from the same cluster.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
The primary and the standby single-instance databases are running from different clusters.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the cluster target that contains the standby single-instance database.
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. (Optional) Perform a database switchover, such that the standby single-instance database becomes the new primary database, and vice versa.

    For information on how to perform a database switchover, see Overview of Switchover and Failover in a Broker Environment in Oracle Data Guard Broker.

  5. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the cluster target that contains the primary single-instance database (or the new standby database, in case you have performed a switchover).
  6. Specify the required deployment options.
  7. Analyze and deploy the plan.
Two primary single-instance databases, P1 and P2, are running from two different clusters, C1 and C2, respectively. Their standby single-instance databases, S1 and S2, are running from C2 and C1, respectively.
  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the first cluster target (C1).
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the second cluster target (C2).
  5. Specify the required deployment options.
  6. Analyze and deploy the plan.

Note:

You can patch the clusters in any order, that is, C1 first and then C2, or C2 first and then C1.
Scenario 4: A primary RAC database, P1, and a primary single-instance database, P2 (that is managed by a CRS or a SIHA target), are running from two different clusters, C1 and C2, respectively. Their standby single-instance databases, S1 and S2, that are managed by CRS or SIHA targets, are running from C2 and C1, respectively.

Follow these steps to apply an Oracle Grid Infrastructure PSU or an Oracle Database PSU on this configuration:

  1. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create a patch plan by selecting the first cluster target (C1).
  2. Specify the required deployment options.
  3. Analyze and deploy the plan.
  4. Search for the required Oracle Grid Infrastructure PSU, or the Oracle Database PSU, then create another patch plan by selecting the second cluster target (C2).
  5. Specify the required deployment options.
  6. Analyze and deploy the plan.

Note:

You can patch the clusters in any order, that is, C1 first and then C2, or C2 first and then C1.