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. Physical backup is not supported for the sys tenant and Meta tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DEST_ID | bigint(20) | NO | The path identifier. |
| ROUND_ID | bigint(20) | NO | The identifier of the backup round. |
| INCARNATION | bigint(20) | NO | The number of incarnations since the Flashback Database operation. |
| DEST_NO | bigint(20) | NO | The identifier of log_archive_dest_n. |
| STATUS | varchar(64) | NO | The archiving status. Valid values: PREPARE, BEGINNING, DOING, INTERRUPTED, STOP, STOPPING, SUSPENDING, and SUSPEND.
|
| START_SCN | bigint(20) unsigned | NO | The starting backup SCN. |
| START_SCN_DISPLAY | datetime(6) | NO | The display of the START_SCN value after it is converted to a time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archiving SCN. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The display of the CHECKPOINT_SCN value after it is converted to a time unit. |
| COMPATIBLE | bigint(20) | NO | The compatibility version. |
| BASE_PIECE_ID | bigint(20) | NO | The ID of the first PIECE in the current backup round. |
| USED_PIECE_ID | bigint(20) | NO | The ID of the last PIECE used in the current backup round. |
| PIECE_SWITCH_INTERVAL | bigint(20) | NO | The piece switching cycle. |
| UNIT_SIZE | bigint(20) | NO | The size of a log block that is compressed or encrypted in a single operation. This field is not supported in OceanBase Database. |
| COMPRESSION | varchar(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | bigint(21) | NO | The size of the data read, in bytes. |
| INPUT_BYTES_DISPLAY | varchar(28) | NO | The display of the INPUT_BYTES value after it is converted to a unit. Valid values: MB, GB, TB, and PB. This field is not supported in OceanBase Database. |
| OUTPUT_BYTES | bigint(21) | NO | The size of the data output, in bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(28) | NO | The display of the OUTPUT_BYTES value after it is converted to a unit. Valid values: MB, GB, TB, and PB. This field is not supported in OceanBase Database. |
| COMPRESSION_RATIO | decimal(24,2) | NO | The compression ratio. This field is not supported in OceanBase Database. |
| DELETED_INPUT_BYTES | bigint(20) | NO | The size of the original data deleted, in bytes. |
| DELETED_INPUT_BYTES_DISPLAY | varchar(27) | NO | The display of the DELETED_INPUT_BYTES value after it is converted to a unit. Valid values: MB, GB, TB, and PB. |
| DELETED_OUTPUT_BYTES | bigint(20) | NO | The size of the effective data deleted, in bytes. |
| DELETED_OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The display of the DELETED_OUTPUT_BYTES value after it is converted to a unit. Valid values: MB, GB, TB, and PB. |
| COMMENT | varchar(262144) | NO | The error message. |
| PATH | varchar(2048) | NO | The archiving path. |
References
For more information about log archiving, see Log archiving.