Purpose
The V$OB_ARCHIVE_DEST_STATUS view displays the status of each log archiving destination at the tenant level.
Note
This view is introduced since OceanBase Database V4.1.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| DEST_ID | NUMBER(38) | NO | The ID of the log archiving destination. |
| PATH | VARCHAR2(4096) | NO | The archive path. |
| STATUS | VARCHAR2(64) | NO | The archiving status. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current archive checkpoint. |
| SYNCHRONIZED | VARCHAR2(32) | NO | Indicates whether the log archive is synchronized with tenant logs. Valid values:
|
| COMMENT | VARCHAR2(262144) | NO | The error prompt. |