Purpose
The DBA_OB_ARCHIVELOG_SUMMARY view displays the status of all historical and current log archiving tasks.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| DEST_ID | NUMBER(38) | NO | The path ID. The system allocates a unique ID to each specified path. |
| ROUND_ID | NUMBER(38) | NO | The nth complete clog backup data flow. |
| INCARNATION | NUMBER(38) | NO | The nth incarnation of the database after the Flashback Database operation. |
| DEST_NO | NUMBER(38) | NO | The log archive destination number. For example, the destination number of log_archive_dest is 0, and that of log_archive_dest_1 is 1. |
| STATUS | VARCHAR2(64) | NO | The status of the backup job. |
| START_SCN | NUMBER(38) | NO | The SCN at which the backup starts. |
| START_SCN_DISPLAY | TIMESTAMP(9) | NO | The value of START_SCN after being converted into the unit of time. |
| CHECKPOINT_SCN | NUMBER(38) | NO | The current archive checkpoint. |
| CHECKPOINT_SCN_DISPLAY | TIMESTAMP(9) | NO | The value of CHECKPOINT_SCN after being converted into the unit of time. |
| COMPATIBLE | NUMBER(38) | NO | The compatibility version. |
| BASE_PIECE_ID | NUMBER(38) | NO | The ID of the first piece of the round. |
| USED_PIECE_ID | NUMBER(38) | NO | The ID of the piece used by the round. |
| PIECE_SWITCH_INTERVAL | NUMBER(38) | NO | The switching interval of pieces. |
| UNIT_SIZE | NUMBER(38) | NO | The size of the log block into which archived log data is compressed or encrypted. At present, this column is not supported. |
| COMPRESSION | VARCHAR2(128) | NO | The compression algorithm. Valid values:
|
| INPUT_BYTES | NUMBER | NO | The volume of data read. At present, OceanBase Database does not support this column. |
| INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the read data with the unit of measurement. For example, the value can be 798.01 M or 5.25 G. At present, OceanBase Database does not support this column. |
| OUTPUT_BYTES | NUMBER | NO | The volume of data output. At present, OceanBase Database does not support this column. |
| OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The size of the output data with the unit of measurement. For example, the value can be 798.01 M or 5.25 G. At present, OceanBase Database does not support this column. |
| COMPRESSION_RATIO | NUMBER | NO | The compression ratio. At present, OceanBase Database does not support this column. |
| DELETED_INPUT_BYTES | NUMBER(38) | NO | The volume of raw data deleted. |
| DELETED_INPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The unit of DELETED_INPUT_BYTES after conversion, which can be MB, GB, TB, or PB. |
| DELETED_OUTPUT_BYTES | NUMBER(38) | NO | The volume of valid data deleted. |
| DELETED_OUTPUT_BYTES_DISPLAY | VARCHAR2(42) | NO | The unit of DELETED_OUTPUT_BYTES after conversion, which can be MB, GB, TB, or PB. |
| PATH | VARCHAR2(2048) | NO | The error prompt. |
| COMMENT | VARCHAR2(262144) | NO | The archive path. |
