Purpose
This view displays the status of all archived logs, both historical and current.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DEST_ID | NUMBER(38) | NO | The ID of the path. The system assigns a unique ID to each path that is set. |
| ROUND_ID | NUMBER(38) | NO | The ID of the complete clog backup data stream. |
| 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 log archiving. Valid values include:
|
| START_SCN | NUMBER(38) | NO | The starting point for backup. |
| START_SCN_DISPLAY | TIMESTAMP(9) | NO | The starting point for backup, converted into a time unit. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current checkpoint SCN. |
| CHECKPOINT_SCN_DISPLAY | TIMESTAMP(9) | NO | The current checkpoint SCN, converted into a time unit. |
| COMPATIBLE | NUMBER(38) | NO | The compatibility version. |
| BASE_PIECE_ID | NUMBER(38) | NO | The ID of the first piece in this round. |
| USED_PIECE_ID | NUMBER(38) | NO | The ID of the piece used in this round. |
| PIECE_SWITCH_INTERVAL | NUMBER(38) | NO | The cycle for switching pieces. |
| UNIT_SIZE | NUMBER(38) | NO | The size of a log block compressed or encrypted each time for log archiving. This column is currently not supported. |
| COMPRESSION | VARCHAR2(128) | NO | The compression algorithm. Valid values include:
|
| INPUT_BYTES | NUMBER | NO | The amount of data read. This column is not supported in OceanBase Database. |
| INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The amount of data read, with units. Valid values include: 798.01 M and 5.25 G. This column is not supported in OceanBase Database. |
| OUTPUT_BYTES | NUMBER | NO | The amount of data output. This column is not supported in OceanBase Database. |
| OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The amount of data output, with units. Valid values include: 798.01 M and 5.25 G. This column is not supported in OceanBase Database. |
| COMPRESSION_RATIO | NUMBER | NO | The compression ratio. This column is not supported in OceanBase Database. |
| DELETED_INPUT_BYTES | NUMBER(38) | NO | The amount of deleted original data. |
| DELETED_INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The amount of deleted original data, with units. Valid values include: MB, GB, TB, and PB. |
| DELETED_OUTPUT_BYTES | NUMBER(38) | NO | The amount of deleted effective data. |
| DELETED_OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The amount of deleted effective data, with units. Valid values include: MB, GB, TB, and PB. |
| PATH | VARCHAR2(2048) | NO | The path for archiving. |
| COMMENT | VARCHAR2(262144) | NO | The error message. |