Note
This view was introduced since OceanBase Database V4.0.0.
Purpose
This view displays the backup parameter information configured for all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| NAME | varchar(1024) | NO | The parameter name. |
| VALUE | longtext | NO | The parameter value. |
Sample query
Under the system tenant, view the backup parameter information configured for all tenants.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_PARAMETER;
The query results are as follows:
+-----------+------------------+------------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | NAME | VALUE |
+-----------+------------------+------------------------------------------------------------------------------------------------------------------------------+
| 1002 | data_backup_dest | oss://example_path/data?host=cn-heyuan.aliyuncs.com&access_id=******&access_key=******&checksum_type=md5&enable_worm=true |
+-----------+------------------+------------------------------------------------------------------------------------------------------------------------------+
1 row in set
References
For detailed descriptions of the parameter values in the backup path, see SET DATA_BACKUP_DEST.