A Oracle Data Guard Broker Upgrading and Downgrading

This appendix guides you through the process of upgrading or downgrading the Oracle databases and Oracle Enterprise Manager Cloud Control (Cloud Control) in a broker configuration. It contains the following topics:

Note:

In an Oracle Data Guard configuration, all physical and snapshot standby databases must use a copy of the password file from the primary database, and that copy must be refreshed whenever an administrative privilege (SYSDG, SYSOPER, SYSDBA, and so on) is granted or revoked, and after the password of any user with administrative privileges is changed.

A.1 Upgrading from Oracle Database 9i Release 2 (9.2) to Oracle Database 12c Release 1 12.1

If you are currently running a broker configuration in Oracle Database 9i Release 2 (9.2), then you must upgrade to Oracle Database 12c Release 1 (12.1) , and then re-create the broker configuration, as follows:.

Delete (remove) the Oracle Database 9i Release 2 (9.2) broker configuration. For example, the DGMGRL REMOVE CONFIGURATION command can be used. To perform the deletion you must use Oracle Data Guard Manager or DGMGRL running on Oracle Database 9i Release 2 (9.2).
If using DGMGRL, clear the LOG_ARCHIVE_DEST_n initialization parameter settings by using the ALTER SYSTEM SET LOG_ARCHIVE_DEST_n=" " SQL*Plus command.
Upgrade the database software to Oracle Database 12c Release 1 (12.1). See the Oracle Database installation documentation that is appropriate for your operating system.
Oracle Enterprise Manager and Oracle Data Guard Manager running on Oracle Database 9i Release 2 (9.2) cannot manage a broker configuration running on Oracle Database 12c Release 1 (12.1).

See Also:

My Oracle Support note 787461.1 at http://support.oracle.com for information about which versions of Enterprise Manager Cloud Control (formerly called Grid Control) are required to manage the full set of Oracle Data Guard features in various Oracle Database releases
If you are using DGMGRL running on Oracle Database 9i Release 2 (9.2), then you must upgrade to DGMGRL running on Oracle Database 12c Release 1 (12.1):
- DGMGRL running on Oracle Database 9i Release 2 (9.2) is not compatible with Oracle Data Guard running on Oracle Database 12c Release 1 (12.1).
- DGMGRL running on Oracle Database 12c Release 1 (12.1) is not compatible with Oracle Data Guard running on Oracle Database 9i Release 2 (9.2).
  
  Note:
  
  Oracle Database 12c command-line scripts are not supported in Oracle9i.
Invoke Enterprise Manager or the DGMGRL command-line interface, and re-create the broker configuration.

A.2 Upgrading from Oracle Database 10g and Oracle Database 11g to Oracle Database 12c Release 1 (12.1)

If you are currently running Oracle Data Guard on Oracle Database 10g or Oracle Database 11g, then you can upgrade the database software to Oracle Database 12c Release 1 (12.1) using the Oracle Database installation documentation that is appropriate for your operating system.

Note:

Prior to Oracle Database 11g Release 2 (11.2), the configuration file was restricted to reside only on disks having the same sector size (physical block size) as that upon which the file was initially created. This was not a problem because there was typically a single sector size in use within a given broker configuration. In anticipation of having mixed sector sizes somewhere within a given broker configuration, the broker configuration file is now completely insensitive to the underlying sector size, so long as the sector size is 4KB or less.

Conversion of the configuration file to be insensitive to the underlying sector size occurs during the upgrade processing in Step 5 below.

Issue the following DGMGRL command to disable fast-start failover:
```
DGMGRL> DISABLE FAST_START FAILOVER;
```
Shut down the 10.n or 11.n Oracle Data Guard broker, whichever version you are running.
1. Issue the following DGMGRL command to disable the broker's active management of the databases in the Oracle Data Guard configuration:
```
DGMGRL> DISABLE CONFIGURATION;
```
2. Issue the following SQL*Plus statement to stop the broker:
```
SQL> ALTER SYSTEM SET DG_BROKER_START=FALSE;
```
Make a copy of the current broker configuration files, as indicated by the following initialization parameters: DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2.
Upgrade the Oracle Database software to Oracle Database 12c Release 1 (12.1). For step-by-step upgrade instructions, see the Oracle Database installation documentation that is appropriate for your operating system.

The DGMGRL command-line interface must also be upgraded in order to manage and monitor a broker configuration running on Oracle Database 12c Release 1 (12.1). DGMGRL running on Oracle Database 12c Release 1 (12.1) cannot be used to manage Oracle Data Guard running on Oracle Database 10g or Oracle Database 11g.

Note:

Existing DGMGRL command-line scripts for Oracle Database 10g and Oracle Database 11g are supported by the DGMGRL command-line interface available in Oracle Database 12c Release 1 (12.1).

DGMGRL command-line scripts for Oracle Database 11g are not guaranteed to be supported by Oracle Database 10g.
After the upgrade to Oracle Database 12c Release 1 (12.1), start the broker. For example:
1. Issue the following SQL*Plus statements to start the broker:
```
SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE;
```
2. Issue the following DGMGRL command to enable the broker's active management of the databases in the Oracle Data Guard configuration:
```
DGMGRL> ENABLE CONFIGURATION
```
The first time the broker starts on Oracle Database 12c Release 1 (12.1) it detects the existence of the Oracle Database 10g and Oracle Database 11g broker configuration files. It automatically upgrades them to include any new properties that were introduced in Oracle Database 12c Release 1 (12.1). This automatic conversion is transparent, permanent, and occurs only once.

Note:

As of this automatic upgrade that occurs in Step 5, the configuration file may henceforth reside on a disk having any supported disk sector size (physical block size) up to and including 4KB sectors.

Note:

The observer that was started prior to the upgrade will automatically be stopped and unable to observe the configuration once the upgrade is complete. You must use an Oracle Database 12c version of the Oracle Observer software to observe Oracle databases running on Oracle Database 12c Release 1 (12.1) or higher.

A.3 Downgrading from Oracle Database 12c Release 1 (12.1)

If you have upgraded to Oracle Database 12c Release 1 (12.1) and want to downgrade to your prior release, then you must downgrade the database release and re-create the broker configuration as follows:

Delete (remove) the Oracle Database 12c Release 1 (12.1) broker configuration using Enterprise Manager or DGMGRL running on Oracle Database 12c Release 1 (12.1). For example, the DGMGRL REMOVE CONFIGURATION command can be used.
Downgrade the Oracle Database software to the prior Oracle release. See the Oracle Database documentation that is appropriate for your operating system.
You can downgrade the Oracle Data Guard broker to Oracle Database 10g or Oracle Database 11g as follows:
- If you are confident that you made no changes to your broker configuration after upgrading to Oracle Database 12c Release 1 (12.1), then you can copy the broker configuration files that you created during the upgrade procedure (described in Upgrading from Oracle Database 10g and Oracle Database 11g to Oracle Database 12c Release 1 (12.1)). Then, invoke Enterprise Manager or the DGMGRL command-line interface and reenable the broker configuration as it existed at the time you made that copy.
- Alternatively, you can invoke Enterprise Manager or the DGMGRL command-line interface to re-create the broker configuration.
You can downgrade the Oracle Data Guard broker to Oracle Database 9i Release 2 (9.2), as follows:
- If you were using Oracle Enterprise Manager, you can continue to use it running on Oracle Database 10g Release 2 (10.2) to manage your Oracle Database 9i Release 2 (9.2) broker configuration. You can also downgrade to the Oracle Data Guard Manager by re-installing Oracle Database 9i Release 2 (9.2) Enterprise Manager.
- Invoke Enterprise Manager, the Oracle Data Guard Manager, or the DGMGRL command-line interface and re-create the broker configuration.

A.4 Preserving Broker Configurations During Rolling Upgrades

If you use Oracle Data Guard broker to manage an Oracle Data Guard configuration and you want to preserve that configuration when you perform a rolling upgrade, then you must do the following:

Disable the broker configuration (using the DGMGRL DISABLE CONFIGURATION command).
Perform a rolling upgrade.
Connect to the current primary database (database whose control file role is PRIMARY) and re-enable the broker configuration (using the DGMGRL ENABLE CONFIGURATION command).

Following this procedure preserves your broker configuration so that you do not have to rebuild it after a rolling upgrade is complete.

This procedure has the following restrictions:

The broker configuration must be enabled after the rolling upgrade is complete.You must ensure that the rolling upgrade is complete before enabling the configuration.
The broker configuration does not support databases running different versions of Oracle. Any standby databases not running the same version of Oracle as the primary database are disabled with an ORA-16673: standby database running different Oracle version error message.
When the broker configuration is disabled, the broker configuration can then only be enabled while connected to a database whose control file role is primary (query the DATABASE_ROLE column of the V$DATABASE view to see which one contains the value PRIMARY).