Overview
Displays the backup parameter information configured for all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| NAME | varchar(1024) | NO | Parameter name |
| VALUE | longtext | NO | Parameter Value |
Sample query
In the sys tenant, view the backup parameter configurations of 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 | s3://example_path/data?host=***&access_id=******&access_key=******&checksum_type=md5 |
+-----------+------------------+------------------------------------------------------------------------------------------------------------------------------+
1 row in set
Note
The sensitive information in the example, such as host, access_id, and access_key, has been masked.
References
For more information about the parameters in the backup path, see SET DATA_BACKUP_DEST.