The Cluster Health Advisor (CHA)
Oracle Cluster Health Advisor
参考手册:
Autonomous Health Framework User’s Guide
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/index.html
Oracle Cluster Health Advisor Architecture
管理命令 chactl Command Reference
chactl monitor
Use the chactl monitor command to start monitoring all the instances of a specific Oracle Real Application Clusters (Oracle RAC) database using the current set model.
chactl unmonitor
Use the chactl unmonitor command to stop monitoring all the instances of a specific database.
chactl status
Use the chactl status command to check monitoring status of the running targets.
chactl config
Use the chactl config command to list all the targets being monitored, along with the current model of each target.
chactl calibrate
Use the chactl calibrate command to create a new model that has greater sensitivity and accuracy.
chactl query diagnosis
Use the chactl query diagnosis command to return problems and diagnosis, and suggested corrective actions associated with the problem for specific cluster nodes or Oracle Real Application Clusters (Oracle RAC) databases.
chactl query model
Use the chactl query model command to list all Oracle Cluster Health Advisor models or to view detailed information about a specific Oracle Cluster Health Advisor model.
chactl query repository
Use the chactl query repository command to view the maximum retention time, number of targets, and the size of the Oracle Cluster Health Advisor repository.
chactl query calibration
Use the chactl query calibration command to view detailed information about the calibration data of a specific target.
chactl remove model
Use the chactl remove model command to delete an Oracle Cluster Health Advisor model along with the calibration data and metadata of the model from the Oracle Cluster Health Advisor repository.
chactl rename model
Use the chactl rename model command to rename an Oracle Cluster Health Advisor model in the Oracle Cluster Health Advisor repository.
chactl export model
Use the chactl export model command to export Oracle Cluster Health Advisor models.
chactl import model
Use the chactl import model command to import Oracle Cluster Health Advisor models.
chactl set maxretention
Use the chactl set maxretention command to set the maximum retention time for the diagnostic data.
chactl resize repository
Use the chactl resize repository command to resize the tablespace of the Oracle Cluster Health Advisor repository based on the current retention time and the number of targets.