Note
This view is available starting with V4.0.0.
Purpose
This view displays the archive path configuration 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, which contains the following fields:
|
| VALUE | varchar(4096) | NO | The value of the name field. |
Sample query
Query the archive path configuration of the 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 | 1002 |
| 0 | path | oss://example_patharchive?host=cn-******.aliyuncs.com&access_id=******&access_key=*****&checksum_type=md5&enable_worm=true |
| 0 | piece_switch_interval | 1d |
| 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.