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