REMOVE_CONFIGURATION
The REMOVE_CONFIGURATION
function can be used to remove
the Data Guard broker configuration.
REMOVE_CONFIGURATION
Function
DBMS_DG.REMOVE_CONFIGURATION (
preserve_destinations IN BOOLEAN DEFAULT FALSE,
severity OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
Parameters
Parameter | Description |
---|---|
preserve_destination |
A boolean value to indicate whether the
log_archive_dest initialization parameter
setting should be preserved or clear when removing member from the
configuration. A value of TRUE indicates that the
parameter setting will not be cleared. A value of
FALSE indicates the parameter setting will be
cleared.
|
severity |
The severity associated with the status returned by
this function. Severity will be one of the following Oracle error
numbers:
|
Usage Notes
-
This function returns a binary integer.
- When you remove a broker configuration, management of all the members associated with that configuration is disabled.
- By default, this function causes the corresponding broker settings
of the
LOG_ARCHIVE_DEST
_n initialization parameter on the primary database and theLOG_ARCHIVE_CONFIG
initialization parameters on all members of the configuration to be removed. To preserve these settings, specify a value of true for thepreserve_destinations
parameter. - This command does not remove or affect the actual primary or standby database instances, databases, far sync instances, data files, control files, initialization parameter files, server parameter files, or log files of the underlying Oracle Data Guard configuration.
- You cannot remove the configuration when fast-start failover is enabled.
Return Values
Error | Description |
---|---|
ORA-00000: normal, successful
completion |
The configuration was successfully removed. |
Other |
The Data Guard broker was unable to remove the configuration and the return value will indicate the reason for this failure. |