Note
This view is available starting with V4.0.0.
Purpose
This view displays the archive path configuration of all tenants.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| DEST_NO | bigint(20) | NO | Identifies log_archive_dest_n |
| NAME | varchar(1024) | NO | Field name. The field contains the following items:
|
| VALUE | varchar(4096) | NO | Value of the field specified by name |
Sample query
The sys tenant views the archive path configuration of the tenant with tenant ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST WHERE TENANT_ID = 1002;
The query result is as follows:
+-----------+---------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | DEST_NO | NAME | VALUE |
+-----------+---------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------+
| 1002 | 0 | binding | OPTIONAL |
| 1002 | 0 | dest_id | 1001 |
| 1002 | 0 | path | oss://example_patharchive?host=cn-******.aliyuncs.com&access_id=******&access_key=*****&checksum_type=md5&enable_worm=true |
| 1002 | 0 | piece_switch_interval | 1d |
| 1002 | 0 | state | ENABLE |
+-----------+---------+-----------------------+-----------------------------------------------------------------------------------------------------------------------------+
5 rows in set
References
For detailed steps and descriptions of viewing archive parameters, see View archive parameters.
For detailed descriptions of the parameter values in archive paths, see SET LOG_ARCHIVE_DEST.