Note
This view was introduced since OceanBase Database V4.0.0.
Purpose
This view displays the configuration of archive paths for all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| DEST_NO | bigint(20) | NO | The log archive destination number. |
| NAME | varchar(1024) | NO | The name of the field. |
| VALUE | varchar(4096) | NO | The value of the field. |
| NAME | varchar(1024) | NO | Field name |
| VALUE | varchar(4096) | NO | Field value |
| NAME | varchar(1024) | NO | Field name |
Sample query
View the archive path configuration information for all tenants under the system tenant.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST;
The query results are as follows:
+-----------+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | DEST_NO | NAME | VALUE |
+-----------+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| 1002 | 0 | binding | OPTIONAL |
| 1002 | 0 | dest_id | 1002 |
| 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 descriptions of the parameter values in the archive path, see SET LOG_ARCHIVE_DEST.