Note
This view is available starting with V4.0.0.
Purpose
This view displays the log archiving status on each path of the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| DEST_ID | NUMBER(38) | NO | The path identifier. |
| ROUND_ID | NUMBER(38) | NO | The backup round identifier. |
| INCARNATION | NUMBER(38) | NO | The incarnation number after Flashback Database is performed. |
| DEST_NO | NUMBER(38) | NO | The identifier of log_archive_dest_n. |
| STATUS | VARCHAR2(64) | NO | The archiving status. Valid values:
|
| START_SCN | NUMBER(38) | NO | The start backup SCN. |
| START_SCN_DISPLAY | TIMESTAMP(9) | NO | The START_SCN converted into a timestamp. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current archiving SCN. |
| CHECKPOINT_SCN_DISPLAY | TIMESTAMP(9) | NO | The CHECKPOINT_SCN converted into a timestamp. |
| COMPATIBLE | NUMBER(38) | NO | The compatibility version. |
| BASE_PIECE_ID | NUMBER(38) | NO | The first PIECE ID of the current round. |
| USED_PIECE_ID | NUMBER(38) | NO | The PIECE ID of the current round. |
| PIECE_SWITCH_INTERVAL | NUMBER(38) | NO | The piece switching cycle. |
| UNIT_SIZE | NUMBER(38) | NO | The size of a single log block that is compressed or encrypted in one operation. This column is not supported. |
| COMPRESSION | VARCHAR2(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | NUMBER | NO | The size of the data read, in bytes. |
| INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the data read, in MB, GB, TB, or PB. |
| OUTPUT_BYTES | NUMBER | NO | The size of the data output, in bytes. |
| OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the data output, in MB, GB, TB, or PB. |
| COMPRESSION_RATIO | NUMBER | NO | The compression ratio. This column is not supported. |
| DELETED_INPUT_BYTES | NUMBER(38) | NO | The size of the original data deleted, in bytes. |
| DELETED_INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the original data deleted, in MB, GB, TB, or PB. |
| DELETED_OUTPUT_BYTES | NUMBER(38) | NO | The size of the effective data deleted, in bytes. |
| DELETED_OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the effective data deleted, in MB, GB, TB, or PB. |
| COMMENT | VARCHAR2(262144) | NO | The error message. |
| PATH | VARCHAR2(2048) | NO | The archiving path. |
Sample query
Query the log archiving status of the current user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_ARCHIVELOG\G
The query result is as follows:
*************************** 1. row ***************************
DEST_ID: 1001
ROUND_ID: 1
INCARNATION: 1
DEST_NO: 0
STATUS: DOING
START_SCN: 1736228322307513000
START_SCN_DISPLAY: 2025-01-07 13:38:42.307513
CHECKPOINT_SCN: 1736232885149619001
CHECKPOINT_SCN_DISPLAY: 2025-01-07 14:54:45.149619
COMPATIBLE: 1
BASE_PIECE_ID: 1
USED_PIECE_ID: 1
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 83551468
INPUT_BYTES_DISPLAY: 79.68MB
OUTPUT_BYTES: 83551468
OUTPUT_BYTES_DISPLAY: 79.68MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
COMMENT:
PATH: file:///home/admin/oceanbase/arglogorc
1 row in set
References
For more information about log archiving, see Log archiving.