Broker management of the primary database and all of its standby databases can be disabled using the DISABLE CONFIGURATION command. After disabling the configuration, it won't be possible to fetch any information from the Data Guard broker by using DGMGRL.
- Before disabling the configuration, let's check the status of the broker configuration, as follows:
DGMGRL> show configuration; Configuration - PACKT Protection Mode: MaxPerformance Databases: turkey_un - Primary database INDIA_UN - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
The current status of the configuration is
SUCCESS. - Disable the configuration as follows:
DGMGRL> disable configuration; Disabled.
- Check the current configuration status as follows:
DGMGRL> show configuration; Configuration - PACKT Protection Mode: MaxPerformance Databases: turkey_un - Primary database INDIA_UN - Physical standby database Fast-Start Failover: DISABLED Configuration Status: DISABLED
You can disable the configuration either from the primary or the standby database. On disabling the broker, databases will not be monitored by the broker. This command won't remove the broker configuration from the configuration file. You're still able to perform changes on the database properties. However, the changes will only be applicable once you enable the configuration again.
We've already seen how to enable configuration of the broker from the initial setup of the Data Guard broker implementation; now we have learned how to disable the Data Guard broker configuration.