Note
This view is available starting with V4.0.0.
Overview
Displays the status of all pieces in the tenant backup set.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| DEST_ID | bigint(20) | NO | Path number. The system assigns a unique ID to each configured path. |
| ROUND_ID | bigint(20) | NO | Identifies the round of the complete clog backup data stream. |
| PIECE_ID | bigint(20) | NO | Backup log shard ID |
| INCARNATION | bigint(20) | NO | Indicates the number of forks after the database is flashed back |
| DEST_NO | bigint(20) | NO | Identifies the log_archive_dest_n, for example, log_archive_dest_0 indicates that dest_no is 0, and log_archive_dest_1 indicates that dest_no is 1. |
| STATUS | varchar(64) | NO | Status of the piece: ACTIVE: The current active piece. FREEZING: The piece is being frozen. FROZEN: The piece has been frozen. After reaching this state, the piece's status will not change. |
| START_SCN | bigint(20) unsigned | NO | Actual Start Offset of Piece |
| START_SCN_DISPLAY | varchar(26) | NO | Display of START_SCN converted to a time unit |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | Current Archive Point |
| CHECKPOINT_SCN_DISPLAY | varchar(26) | NO | Display after converting CHECKPOINT_SCN to a time unit |
| MAX_SCN | bigint(20) unsigned | NO | Maximum Archive Timestamp |
| END_SCN | bigint(20) unsigned | NO | Theoretically final offset of the piece |
| COMPATIBLE | bigint(20) | NO | Compatible version number for log archiving |
| UNIT_SIZE | bigint(20) | NO | The size of a log block that is compressed or encrypted during log archiving. This field is not supported. |
| COMPRESSION | varchar(128) | NO | Compression algorithm:
|
| INPUT_BYTES | bigint(20) | NO | Original data volume, in bytes |
| INPUT_BYTES_DISPLAY | varchar(27) | NO | Display after converting the unit of INPUT_BYTES |
| OUTPUT_BYTES | bigint(20) | NO | The amount of encrypted and compressed data, in bytes |
| OUTPUT_BYTES_DISPLAY | varchar(27) | NO | Display of OUTPUT_BYTES after unit conversion |
| COMPRESSION_RATIO | decimal(23,2) | NO | Compression Ratio |
| FILE_STATUS | varchar(64) | NO | File status of backup log shards:
|
| PATH | varchar(2048) | NO | Archive Path |
Sample query
The system tenant queries the status of pieces in the backup set of the tenant with ID 1002.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_PIECE_FILES WHERE TENANT_ID = 1002\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
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: 1736233365380528000
CHECKPOINT_SCN_DISPLAY: 2025-01-07 15:02:45.380528
MAX_SCN: 1736233365682585000
END_SCN: 1736314722307513000
END_SCN_DISPLAY: 2025-01-08 13:38:42.307513
COMPATIBLE: 1
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 84860528
INPUT_BYTES_DISPLAY: 80.93MB
OUTPUT_BYTES: 84860528
OUTPUT_BYTES_DISPLAY: 80.93MB
COMPRESSION_RATIO: 1.00
FILE_STATUS: AVAILABLE
PATH: file:///home/admin/oceanbase/arglog
1 row in set
References
For more information about pieces, see Log archiving overview.