Purpose
This view displays the status of pieces in a backup set.
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. |
| PIECE_ID | NUMBER(38) | NO | The ID of the backup log piece. |
| INCARNATION | NUMBER(38) | NO | The number of times the Flashback Database has been incarnated. |
| DEST_NO | NUMBER(38) | NO | The ID of log_archive_dest_n. For example, the dest_no of log_archive_dest is 0, and that of log_archive_dest_1 is 1. |
| STATUS | VARCHAR2(64) | NO | The status of the piece: |
| START_SCN | NUMBER(38) | NO | The starting SCN of the piece. |
| START_SCN_DISPLAY | TIMESTAMP(9) | NO | The starting SCN of the piece converted into a time unit. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current archive SCN. |
| CHECKPOINT_SCN_DISPLAY | TIMESTAMP(9) | NO | The current archive SCN converted into a time unit. |
| MAX_SCN | NUMBER(38) | NO | The maximum archive SCN. |
| END_SCN | NUMBER(38) | NO | The theoretical ending SCN of the piece. |
| COMPATIBLE | NUMBER(38) | NO | The compatible version of log archiving. |
| UNIT_SIZE | NUMBER(38) | NO | The size of each log block that is compressed or encrypted in a single log archiving operation. The value of this field is not supported at present. |
| COMPRESSION | VARCHAR2(128) | NO | The compression algorithm used:
|
| INPUT_BYTES | NUMBER(38) | NO | The original data size. |
| INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The original data size in a supported unit. |
| OUTPUT_BYTES | NUMBER(38) | NO | The size of the effective data after the data is encrypted and compressed. |
| OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the effective data after the data is encrypted and compressed in a supported unit. |
| COMPRESSION_RATIO | NUMBER | NO | The compression ratio. |
| FILE_STATUS | VARCHAR2(64) | NO | The file status of the backup log piece: |
| PATH | VARCHAR2(2048) | NO | The archive path. |