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 field, which 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 archive parameters, see View archive parameters.
For more information about the parameters in the archive path, see SET LOG_ARCHIVE_DEST.