Feature
This view shows the file status of backup sets.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| BACKUP_SET_ID | bigint(20) | NO | The ID of the backup set. |
| DEST_ID | bigint(20) | NO | The ID of the backup path. |
| INCARNATION | bigint(20) | NO | The nth incarnation of the database after the Flashback Database operation. |
| BACKUP_TYPE | varchar(1) | NO | The type of the backup. Valid values: |
| PREV_FULL_BACKUP_SET_ID | bigint(20) | NO | The backup set ID of the previous full backup on which the current backup set depends. |
| PREV_INC_BACKUP_SET_ID | bigint(20) | NO | The backup set ID of the previous incremental backup on which the current backup set depends. |
| START_TIMESTAMP | timestamp(6) | NO | The timestamp when the secondary backup of the backup set started. |
| END_TIMESTAMP | varchar(26) | NO | The timestamp when the secondary backup of the backup set is completed. |
| STATUS | varchar(64) | NO | The backup status. |
| FILE_STATUS | varchar(64) | NO | The file status of the backup set. Valid values: |
| ELAPSED_SECONDES | decimal(22,0) | NO | The time consumed for the backup. |
| PLUS_ARCHIVELOG | varchar(4096) | NO | Indicates whether log synchronization is enabled. |
| START_REPLAY_SCN | bigint(20) unsigned | NO | The playback SCN of the backup set dependency log. |
| START_REPLAY_SCN_DISPLAY | varchar(26) | NO | The playback timestamp of the backup set dependency log. |
| MIN_RESTORE_SCN | bigint(20) unsigned | NO | The latest recoverable SCN of the backup set. |
| MIN_RESTORE_SCN_DISPLAY | varchar(26) | NO | The minimum recoverable timestamp of the backup set. |
| INPUT_BYTES | bigint(20) | YES | The number of input bytes. |
| OUTPUT_BYTES | bigint(20) | YES | The number of output bytes. |
| OUTPUT_RATE_BYTES | decimal(28,4) | NO | The number of bytes that are output per second. |
| EXTRA_META_BYTES | bigint(20) | YES | The number of extra bytes. |
| TABLET_COUNT | bigint(20) | YES | The total number of backup TABLETs. |
| FINISH_TABLET_COUNT | bigint(20) | YES | The total number of TABLETs backed up. |
| MACRO_BLOCK_COUNT | bigint(20) | YES | The total number of backup macroblocks. |
| FINISH_MACRO_BLOCK_COUNT | bigint(20) | YES | The total number of macroblocks backed up. |
| FILE_COUNT | bigint(20) | YES | The number of backup files. |
| META_TURN_ID | bigint(20) | YES | The round of the backup META. |
| DATA_TURN_ID | bigint(20) | YES | The round of the backup data. |
| RESULT | bigint(20) | NO | The returned backup error code. |
| COMMENT | varchar(4096) | YES | The description of the backup error code. |
| ENCRYPTION_MODE | varchar(64) | YES | The encryption mode. Valid values: Currently, only the None and Password modes are supported. |
| PASSWD | varchar(128) | YES | The password. |
| TENANT_COMPATIBLE | varchar(4096) | NO | The tenant version number. |
| BACKUP_COMPATIBLE | bigint(20) | NO | The version number of the backup set. |
| PATH | varchar(4096) | YES | The backup path. |