ODA/KVM How to delete a DG config in the metadata

Occasionally, the only solution to address DG registration or configuration issue may be to remove tghe metadata from the ODA.

To remove the DG metadata, process as below (at your own risk):

Stop the agent and launch mysql (from root)

[root#]systemctl stop initdcsagent
/opt/oracle/dcs/mysql/bin/mysql --defaults-file=/opt/oracle/dcs/mysql/etc/mysqldb.cnf
use dcsagentdb

Check the existing medata:

mysql>
Select name from db; <= to check this is the correct DBsystem

Update the metadata accordingly, for example:

delete from DG_CONFIGURATION_V2_REPLICATION_GROUP_V2;
delete from DG_CONFIGURATION_V2;

Restart the agent.

[root#]systemctl start initdcsagent