Note
This view is available starting with V4.0.0.
Purpose
This view displays the status of pieces in the backup set of the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DEST_ID | NUMBER(38) | NO | The path ID. The system assigns a unique ID to each configured path. |
| ROUND_ID | NUMBER(38) | NO | The ID of the round of complete clog backup data streams. |
| PIECE_ID | NUMBER(38) | NO | The ID of the backup log piece. |
| INCARNATION | NUMBER(38) | NO | The number of incarnations after Flashback Database. |
| DEST_NO | NUMBER(38) | NO | The ID of log_archive_dest_n. For example, the dest_no of log_archive_dest is 0, and the dest_no of log_archive_dest_1 is 1. |
| STATUS | VARCHAR2(64) | NO | The status of the piece. Valid values:
|
| START_SCN | NUMBER(38) | NO | The starting point of the piece. |
| START_SCN_DISPLAY | TIMESTAMP(9) | NO | The start time of the piece. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current archive point. |
| CHECKPOINT_SCN_DISPLAY | TIMESTAMP(9) | NO | The current archive time. |
| MAX_SCN | NUMBER(38) | NO | The maximum archive point. |
| END_SCN | NUMBER(38) | NO | The theoretical end point of the piece. |
| COMPATIBLE | NUMBER(38) | NO | The compatible version number of log archiving. |
| UNIT_SIZE | NUMBER(38) | NO | The size of a single log block that is compressed or encrypted during log archiving. This column is not supported. |
| COMPRESSION | VARCHAR2(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | NUMBER(38) | NO | The size of the original data, in bytes. |
| INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the original data after unit conversion. |
| OUTPUT_BYTES | NUMBER(38) | NO | The size of the effective data after encryption and compression, in bytes. |
| OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the effective data after encryption and compression, after unit conversion. |
| COMPRESSION_RATIO | NUMBER | NO | The compression ratio. |
| FILE_STATUS | VARCHAR2(64) | NO | The file status of the backup log piece. Valid values:
|
| PATH | VARCHAR2(2048) | NO | The archive path. |
Sample query
Query the status of pieces in the backup set of the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_ARCHIVELOG_PIECE_FILES\G
The query result is as follows:
*************************** 1. row ***************************
DEST_ID: 1002
ROUND_ID: 1
PIECE_ID: 1
INCARNATION: 1
DEST_NO: 0
STATUS: ACTIVE
START_SCN: 1736228322307513000
START_SCN_DISPLAY: 2025-01-07 13:38:42.307513
CHECKPOINT_SCN: 1736233485415914000
CHECKPOINT_SCN_DISPLAY: 2025-01-07 15:04:45.415914
MAX_SCN: 1736233485717186000
END_SCN: 1736314722307513000
END_SCN_DISPLAY: 2025-01-08 13:38:42.307513
COMPATIBLE: 1
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 85183742
INPUT_BYTES_DISPLAY: 81.24MB
OUTPUT_BYTES: 85183742
OUTPUT_BYTES_DISPLAY: 81.24MB
COMPRESSION_RATIO: 1.00
FILE_STATUS: AVAILABLE
PATH: file:///home/admin/oceanbase/arglogorc
1 row in set
References
For more information about pieces, see Overview of log archiving.