B Data Guard Broker Upgrading and Downgrading

B.1 Upgrade from Release 9.2.0 to Release 11.1

If you are currently running an Oracle Data Guard release 9.2.0 configuration, you must upgrade to Oracle Database release 11.1, and re-create the broker configuration, as follows:

1. Delete (remove) the release 9.2.0 broker configuration using Data Guard Manager or DGMGRL release 9.2.0. For example, the DGMGRL REMOVE CONFIGURATION command can be used.

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.

3. Upgrade the database software to Oracle release 11.1. See the Oracle Database installation documentation that is appropriate for your operating system.

4. If you are using Oracle Enterprise Manager and Data Guard Manager release 9.2.0, you must upgrade to Oracle Enterprise Manager release 10.2 to manage a broker configuration running Oracle Data Guard release 11.1. Data Guard Manager release 9.2.0 is not compatible with Oracle Data Guard release 11.1.

5. If you are using DGMGRL release 9.2.0, you must upgrade to Data Guard command-line interface release 11.1:

   • DGMGRL release 9.2.0 is not compatible with Oracle Data Guard release 11.1.

     Note:

     Existing Oracle9i command-line scripts are supported in Oracle Database 11.1 for non-RAC databases. See Appendix A for information about deprecated commands.

   • DGMGRL release 11.1 is not compatible with Oracle Data Guard release 9.2.0.

     Note:

     Oracle Database 11.1 command-line scripts are not supported in Oracle9i.

6. Invoke Enterprise Manager or the DGMGRL command-line interface, and re-create the broker configuration.

B.2 Upgrade from Release 10.n to Release 11.1

If you are currently running an Oracle Data Guard release 10.n configuration, you can upgrade the database software to Oracle release 11.1 using the Oracle Database installation documentation that is appropriate for your operating system.

Step 1   Shut down the 10.n Data Guard broker.

Disable the broker's management of the configuration and then stop the broker. For example:

1. Issue the following DGMGRL command to disable the broker's active management of the databases in the 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;
   

Step 2   Make a copy of the current broker configuration files.

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.

Step 3   Upgrade the Oracle Database software to release 11.1.

For step-by-step upgrade instructions, see the Oracle Database installation documentation that is appropriate for your operating system.

To upgrade Oracle Enterprise Manager Grid Control or DGMGRL, consider the following:

• If you are running Oracle Enterprise Manager Grid Control release 10.n, you can use it to manage a broker configuration running Oracle Data Guard release 11.1.

• If you are using DGMGRL release 10.n, you must upgrade to Data Guard command-line interface release 11.1 to manage a broker configuration running Oracle Data Guard release 11.1.

  Note:

  Existing release 10.n DGMGRL command-line scripts are supported by the DGMGRL command-line interface available in release 11.1.

  Release 11.1 DGMGRL command-line scripts are not guaranteed to be supported by Oracle Database release 10.n.

Step 4   Start the broker.

After the upgrade, start the release 11.1 Data Guard 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 Data Guard configuration:

   DGMGRL> ENABLE CONFIGURATION
   

The first time the release 11.1 broker starts, it will detect the existence of the release 10.n broker configuration files and automatically upgrade them to include any new properties that were introduced in release 11.1 (for example, the fast-start failover properties). This automatic conversion is transparent, permanent, and occurs only once.

B.3 Downgrade from Release 11.1

If you have upgraded to release 11.1 and want to downgrade to your prior release, you must downgrade the database release and re-create the broker configuration as follows:

1. Delete (remove) the release 11.1 broker configuration using Enterprise Manager or DGMGRL release 11.1. For example, the DGMGRL REMOVE CONFIGURATION command can be used.

2. Downgrade the Oracle Database software to the prior Oracle release. See the Oracle Database documentation that is appropriate for your operating system.

3. You can downgrade the Data Guard broker to release 10.n, as follows:

   • If you are confident that you made no changes to your broker configuration after upgrading to release 11.1, you can copy the broker configuration files that you created during the upgrade procedure (described in Section B.2). 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.

4. You can downgrade the Data Guard broker to Oracle release 9.2.0, as follows:

   • If you were using Enterprise Manager, you can continue to use the Oracle Enterprise Manager release 10.2 to manage your 9.2.0 broker configuration. You can also downgrade to the Data Guard Manager by re-installing Oracle Enterprise Manager release 9.2.0.

   • Invoke Enterprise Manager, the Data Guard Manager, or the DGMGRL command-line interface and re-create the broker configuration.