Purpose
v$ob_cluster_event_history displays the event history related to the primary and standby databases in the cluster. It tracks detailed information on O&M and switchover processes, as well as error logs to facilitate problem diagnosis.
Fields
| Field |
Type |
Nullable? |
Description |
| facility |
varchar(64) |
NO |
The operation that produced the event. Valid values: add clusterremove clusterenable cluster synchronizationdisable cluster synchronizationswitchover to physical standbyswitchover to primaryfailover to primaryconvert to physical standbyset cluster protection modeupdate protection level in maximum availability modeupdate sync standby protection level: The protection level of the standby cluster is updated from RESYNCHRONIZATION to MAXIMIZE AVAILABLE or MAXIMIZE PROTECTION.amend primary protection level: When the protection level and protection mode of the primary cluster do not match, the protection level needs to be adjusted or the protection mode needs to be rolled back.amend standby protection level: When the protection level of the standby cluster does not match the protection mode of the primary cluster, the protection level of the standby cluster needs to be adjusted. |
| severity |
varchar(256) |
YES |
The severity of the event. Valid values: CONTROL: indicates an expected event, such as the start or end of a switchover, failover, adding cluster, or removing cluster operation.INFO: indicates a regular message event.WARN: indicates a warning message event.ERROR: indicates an error message event. |
| error_code |
varchar(256) |
YES |
The error code of the event. The value 0 indicates that no error has occurred. |
| timestamp |
timestamp(6) |
NO |
Date |
| message |
varchar(256) |
YES |
The content of the alert message. |
