CREATE_CONFIGURATION

The CREATE_CONFIGURATION function can be used to create a Data Guard broker configuration. The primary database will be automatically added to the configuration. The value of the primary database's DB_UNIQUE_NAME initialization parameter value will be fetched from the database.

CREATE_CONFIGURATION Function

DBMS_DG.CREATE_CONFIGURATION (
     config_name          IN VARCHAR2,
     primary_ci           IN VARCHAR2,
     severity             OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;

Parameters

Parameter	Description
config_name	A user-friendly name for the configuration you are creating. Valid names contain any alphanumeric characters. If spaces are included in the name, the name must be enclosed in double or single quotation marks. The name must consist of 30 or fewer bytes.
primary_ci	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.
severity	The severity associated with the status returned by this function. Severity will be one of the following Oracle error numbers: ORA-0: normal, successful completion ORA-16501: The Oracle Data Guard broker operation failed. ORA-16502: The Oracle Data Guard broker operation succeeded with warnings.

Usage Notes

• This function returns a binary integer.

• This function can only be called while connected to a primary database.

Return Values

Error	Description
ORA-00000: normal, successful completion	The Data Guard broker configuration was created and the primary database has been added to the configuration.
Other	The Data Guard broker was unable to convert the database and the return value will indicate the reason for this failure.