Note
This view was introduced in OceanBase Database V4.0.0.
Purpose
This view displays the backup parameters configured for the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| NAME | varchar2(1024) | NO | The name of the parameter. |
| VALUE | CLOB | NO | The value of the parameter. |
Sample query
User tenants can view the backup parameter information configured for their own tenant.
obclient[SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_PARAMETER;
The query results are as follows:
+------------------+------------------------------------------------------------------------------------------------------------------------------+
| NAME | VALUE |
+------------------+------------------------------------------------------------------------------------------------------------------------------+
| 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.