Note
This view is available starting with V4.0.0.
Purpose
This view displays the log archiving status for 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 identifier of the path. |
| ROUND_ID | bigint(20) | NO | The identifier of the backup round. |
| INCARNATION | bigint(20) | NO | The number of incarnations after Flashback Database. |
| DEST_NO | bigint(20) | NO | The identifier of log_archive_dest_n. |
| STATUS | varchar(64) | NO | The archiving status. Valid values:
|
| START_SCN | bigint(20) unsigned | NO | The starting backup point. |
| START_SCN_DISPLAY | datetime(6) | NO | The converted value of START_SCN in the time unit. |
| CHECKPOINT_SCN | bigint(20) unsigned | NO | The current archiving point. |
| CHECKPOINT_SCN_DISPLAY | datetime(6) | NO | The converted value of CHECKPOINT_SCN in the 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 interval for switching PIECES. |
| UNIT_SIZE | bigint(20) | NO | The size of a single log block that is compressed or encrypted in the log archiving process. This field is not supported. |
| 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 converted value of INPUT_BYTES in the MB, GB, TB, or PB unit. |
| OUTPUT_BYTES | bigint(21) | NO | The size of the data output, in bytes. |
| OUTPUT_BYTES_DISPLAY | varchar(28) | NO | The converted value of OUTPUT_BYTES in the MB, GB, TB, or PB unit. |
| COMPRESSION_RATIO | decimal(24,2) | NO | The compression ratio. This field is not supported. |
| DELETED_INPUT_BYTES | bigint(20) | NO | The size of the original data deleted, in bytes. |
| DELETED_INPUT_BYTES_DISPLAY | varchar(27) | NO | The converted value of DELETED_INPUT_BYTES in the MB, GB, TB, or PB unit. |
| DELETED_OUTPUT_BYTES | bigint(20) | NO | The size of the effective data deleted, in bytes. |
| DELETED_OUTPUT_BYTES_DISPLAY | varchar(27) | NO | The converted value of DELETED_OUTPUT_BYTES in the MB, GB, TB, or PB unit. |
| COMMENT | varchar(262144) | NO | The error message. |
| PATH | varchar(2048) | NO | The archiving path. |
References
For more information about log archiving, see Log archiving.