Note
This view is available starting with V4.0.0.
Purpose
This view displays the archive path configurations of the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| DEST_NO | bigint(20) | NO | The identifier of log_archive_dest_n. |
| NAME | varchar(1024) | NO | The name of the field. |
| VALUE | varchar(4096) | NO | The value of the field. |
Sample query
Query the archive path configurations of the current user tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_ARCHIVE_DEST;
The query result is as follows:
+---------+-----------------------+-------------------------------------+
| DEST_NO | NAME | VALUE |
+---------+-----------------------+-------------------------------------+
| 0 | binding | OPTIONAL |
| 0 | dest_id | 1001 |
| 0 | path | file:///home/admin/oceanbase/arglog |
| 0 | piece_switch_interval | 1d |
| 0 | state | ENABLE |
+---------+-----------------------+-------------------------------------+
5 rows in set