Note
- For OceanBase Database V4.3.x, this parameter was introduced in OceanBase Database V4.3.2.
- For OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.3.
Description
alert_log_level specifies the level of alert logs.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter only in the
systenant.
Attributes
| Attribute | Description |
|---|---|
| Type | String |
| Default value | INFO |
| Value range | INFO, WARN, and ERROR
NoteThe priority of the log levels is as follows: ERROR > WARN > INFO. |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
Alert logs are stored in the alert.log file under the log/alert directory. Alert logs include key INFO, WARN, and ERROR logs generated during system running. For more information, see Alert logs.
Examples
Set the level of alert logs to INFO.
obclient> ALTER SYSTEM SET alert_log_level='INFO';