A Oracle Data Guard Broker Upgrading and Downgrading
Use these topics to upgrade or downgrade Oracle databases and Oracle Enterprise Manager Cloud Control (Cloud Control) in a broker configuration.
-
Upgrading from Oracle Database 9i Release 2 (9.2) to Oracle Database 12c
-
Upgrading from Oracle Database 10g and Oracle Database 11g to Oracle Database 12c
See Also:
A.1 Upgrading from Oracle Database 9i Release 2 (9.2) to Oracle Database 12c
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) or Oracle Database 12c Release 2 (12.2), and then re-create the broker configuration.
The following steps use Oracle Database 12c Release 2 (12.2), but you could substitute Oracle Database 12c Release 1 (12.1).
A.2 Upgrading from Oracle Database 10g and Oracle Database 11g to Oracle Database 12c
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) or Oracle Database 12c Release 2 (12.2) 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.
The following steps use Oracle Database 12c Release 2 (12.2), but you could substitute Oracle Database 12c Release 1 (12.1).
-
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.
-
Issue the following DGMGRL command to disable the broker's active management of the databases in the Oracle Data Guard configuration:
DGMGRL> DISABLE CONFIGURATION;
-
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
andDG_BROKER_CONFIG_FILE2
. -
Upgrade the Oracle Database software to Oracle Database 12c Release 2 (12.2). 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 2 (12.2). DGMGRL running on Oracle Database 12c Release 2 (12.2) 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 2 (12.2).
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 2 (12.2), start the broker. For example:
-
Issue the following SQL*Plus statements to start the broker:
SQL> ALTER SYSTEM SET DG_BROKER_START=TRUE;
-
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 2 (12.2) 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 2 (12.2). 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 2 (12.2) or higher.
A.3 Downgrading from Oracle Database 12c
If you have upgraded to Oracle Database 12c Release 1 (12.1) or Oracle Database 12c Release 2 (12.2) and want to downgrade to your prior release, then you must downgrade the database release and re-create the broker configuration.
Take the following steps (these steps use Oracle Database 12c Release 2 (12.2), but you could substitute Oracle Database 12c Release 1 (12.1)).