Overview
Displays the archive path configuration information for all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| DEST_NO | bigint(20) | NO | Identifier log_archive_dest_n |
| NAME | varchar(1024) | NO | Field name, containing the following fields:
|
| VALUE | varchar(4096) | NO | name Field Value |
Sample query
In the sys tenant, view the archive path configuration information for all tenants.
obclient[oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVE_DEST;
The query result is as follows:
+-----------+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| TENANT_ID | DEST_NO | NAME | VALUE |
+-----------+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| 1002 | 0 | binding | OPTIONAL |
| 1002 | 0 | dest_id | 1002 |
| 1002 | 0 | path | s3://example_patharchive?host=***&access_id=******&access_key=*****&checksum_type=md5 |
| 1002 | 0 | piece_switch_interval | 1d |
| 1002 | 0 | state | ENABLE |
+-----------+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
5 rows in set
Note
The sensitive information such as host, access_id, and access_key in the example has been masked.
References
For detailed operations and descriptions on Viewing archive parameters, see View archive parameters.
For more information about the parameters in the archive path, see SET LOG_ARCHIVE_DEST.