ADD CONFIGURATION

The ADD CONFIGURATION command establishes a relationship between two Data Guard broker configurations by adding a broker configuration to the current configuration.

Prerequisites

  • There must be no traditional Data Guard configured by way of standby databases.

  • The initialization parameter DG_BROKER_START must be set to TRUE.

  • The DG_BROKER_CONFIG_FILE parameter must be configured correctly.

  • A server parameter file (spfile) must be created in the source CDB and target CDB.

Format

ADD CONFIGURATION <configuration_name> CONNECT IDENTIFIER IS <connect_identifier>;

Parameters

Parameter Description
configuration_name

Name of the broker configuration that must be added. This configuration must contain one primary database and no standby databases.
connect_identifier

Oracle net connect identifier used to connect to the primary database in the configuration_name. The connect identifier must correspond to a primary database.

Usage Notes

  • Redo transport is automatically set up between the primary databases in the two broker configurations after the target PDBs are added. However, no primary database is designated as the source or target at this point.

  • The configuration name must be different from any other configuration that already exists in the broker metadata.

Examples

Example 10-4 Establishing a Connection Between Two Broker Configurations

This example adds a configuration named MyConfig2 to the current configuration, MyConfig1. The Oracle net connect identifier to connect to the primary database in MyConfig2 is newyork_ci. 

DGMGRL> ADD CONFIGURATION 'MyConfig2' CONNECT IDENTIFIER IS newyork_ci;
    Added configuration “MyConfig2” with primary database “newyork”.