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 | NUMBER(38) | NO | The identifier of log_archive_dest_n. |
| NAME | VARCHAR2(1024) | NO | The name of the archive destination. The name contains the following fields:
|
| VALUE | VARCHAR2(4096) | NO | The value corresponding to the name field. |
Sample query
Query the archive path configuration of the user tenant.
obclient[SYS]> SELECT * FROM SYS.DBA_OB_ARCHIVE_DEST;
The query result is as follows:
+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| DEST_NO | NAME | VALUE |
+---------+-----------------------+-------------------------------------------------------------------------------------------------------------------------------+
| 0 | binding | OPTIONAL |
| 0 | dest_id | 1004 |
| 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.