ADD DATABASE

The DGMGRL ADD DATABASE command adds a standby database to an existing broker configuration.

Format

ADD DATABASE <db_unique_name> AS CONNECT IDENTIFIER IS <connect_identifier>;

Command Parameters

db-unique-name

The name that will be used by the broker to refer to this standby database. It must match (case-insensitive) the value of the corresponding database DB_UNIQUE_NAME initialization parameter.

<connect_identifier>

A fully specified connect descriptor or a name to be resolved by an Oracle Net Services naming method (for example, TNS). The value you specify is also used as the initial value of the DGConnectIdentifier database property.

Usage Notes

  • To issue this command, you must connect to the primary database or to an enabled standby database that is already in the configuration.

  • The broker uses the specified <connect_identifier> to communicate with the specified database from other databases. Therefore, you must ensure that the <connect_identifier> can be used to address the specified database from all databases in your configuration. For example, if TNS is used as the naming method, you must ensure that the tnsnames.ora file on every database and instance that is part of the configuration contains an entry for the <connect_identifier>. The connect identifier must resolve to the same connect descriptor. If the database that is being added is an Oracle RAC database, the <connect_identifier> provided here must reach all instances of the Oracle RAC, preferably with FAILOVER attributes set.

    See Also:

    Oracle Database Net Services Administrator's Guide

  • If the connection cannot be made, the broker does not add the new database to the configuration.

Command Example

The following example shows how to add a database named South_Sales. 

DGMGRL> ADD DATABASE South_Sales AS CONNECT IDENTIFIER IS South_Sales.example.com;
Database "South_Sales" added