Note
This view is available starting with V4.0.0.
Purpose
This view displays the backup parameters 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
In the sys tenant, query the backup parameters configured for all tenants.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_PARAMETER;
The query result is 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 more information about the parameter values in the backup path, see SET DATA_BACKUP_DEST.