Note
This view is available starting with V4.0.0.
Purpose
This view displays the archive path configurations of all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| DEST_NO | bigint(20) | NO | The identifier of log_archive_dest_n. |
| NAME | varchar(1024) | NO | The name of the field, which contains the following fields:
|
| VALUE | varchar(4096) | NO | The value of the name field. |
Sample query
Query the archive path configurations of the tenant with the ID 1002 in the sys tenant.
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 | file:///home/admin/oceanbase/arglog |
| 1002 | 0 | piece_switch_interval | 1d |
| 1002 | 0 | state | ENABLE |
+-----------+---------+-----------------------+-------------------------------------+
5 rows in set
References
For more information about how to view the archive parameters, see View archive parameters.
For more information about the parameters in the archive path, see SET LOG_ARCHIVE_DEST.