DISABLE DATABASE
The DISABLE DATABASE command disables broker management of the named standby database.
This means that broker directed state changes will be disallowed for this database, and the broker will not monitor the database for health status or for monitorable properties.
Format
DISABLE DATABASE <db_unique_name>;
Usage Notes
-
You cannot specify the name of a primary database.
-
Use the
DISABLE CONFIGURATIONcommand to disable the primary and all standby databases. -
If the sole standby database is disabled, you have no failover option. This standby database is not viable for failover until it is reenabled.
-
This command cannot be used to disable the fast-start failover target database when fast-start failover is enabled.
Command Example
The following example shows how to disable a database named South_Sales.
DGMGRL> DISABLE DATABASE 'South_Sales'; Disabled.