Note
This view is available starting with V4.0.0.
Purpose
This view displays the file status of the backup sets of the current user.
Columns
| Column | Type | Nullable | Description | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BACKUP_SET_ID | NUMBER(38) | NO | Backup set ID | Column | Type | Nullable | Description | --- | --- | --- | --- | BACKUP_SET_ID | NUMBER(38) | NO | Backup set ID | |||
| Column | Type | Nullable | Description | --- | --- | --- | --- | DEST_ID | NUMBER(38) | NO | Backup path ID | |||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | INCARNATION | NUMBER(38) | NO | The number of incarnations since Flashback Database was last used. | |||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | BACKUP_TYPE | VARCHAR2(64) | NO | The backup type.
|
|||||||
| PREV_FULL_BACKUP_SET_ID | NUMBER(38) | NO | This view displays the BACKUP_SET_ID of the previous full backup set from which the current backup set depends. | |||||||||||||||
| PREV_INC_BACKUP_SET_ID | NUMBER(38) | NO | The BACKUP_SET_ID of the previous incremental backup that the current backup set depends on. | |||||||||||||||
| START_TIMESTAMP | VARCHAR2(256) | NO | Timestamp when the backup set started. | |||||||||||||||
| END_TIMESTAMP | VARCHAR2(256) | NO | The backup set end timestamp | |||||||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | STATUS | varchar2(64) | NO | Backup status. | |||||||
| FILE_STATUS | varchar2(64) | NO | The status of the backupset file. The value can be one of the following:
|
|||||||||||||||
| ELAPSED_SECONDS | NUMBER | NO | The backup time. | |||||||||||||||
| PLUS_ARCHIVELOG | varchar2(4096) | NO | Whether to enable log padding | |||||||||||||||
| START_REPLAY_SCN | NUMBER(38) | NO | The SCN at which log replay of the backup set begins. | |||||||||||||||
| START_REPLAY_SCN_DISPLAY | TIMESTAMP(9) | NO | The time stamp of the log replay start point of the backup set | |||||||||||||||
| MIN_RESTORE_SCN | NUMBER(38) | NO | The earliest restore SCN of a backup set. | |||||||||||||||
| MIN_RESTORE_SCN_DISPLAY | VARCHAR2(4096) | NO | The smallest restore SCN that can be restored to the backup set | |||||||||||||||
| INPUT_BYTES | NUMBER(38) | YES | The number of input bytes. | |||||||||||||||
| Output Bytes | NUMBER(38) | YES | Output bytes. | |||||||||||||||
| COLUMN | TYPE | NULLABLE | DESCRIPTION | --- | --- | --- | --- | OUTPUT_RATE_BYTES | NUMBER | NO | Output rate (bytes per second) | |||||||
| EXTRA_META_BYTES | NUMBER(38) | YES | Extra bytes | |||||||||||||||
| TABLET_COUNT | NUMBER(38) | YES | Backup tablet count | |||||||||||||||
| FINISH_TABLET_COUNT | NUMBER(38) | YES | The total number of completed backup tablets. | |||||||||||||||
| MACRO_BLOCK_COUNT | NUMBER(38) | YES | Total number of macro blocks backed up | |||||||||||||||
| FINISH_MACRO_BLOCK_COUNT | NUMBER(38) | YES | The total number of backup macroblocks completed. | |||||||||||||||
| FILE_COUNT | NUMBER(38) | YES | The number of backup files | |||||||||||||||
| Column | Type | Nullable | Description | --- | --- | --- | --- | META_TURN_ID | NUMBER(38) | YES | The backup turn of the metadata. | |||||||
| DATA_TURN_ID | NUMBER(38) | YES | The turn of the backup data. | |||||||||||||||
| RESULT | NUMBER(38) | NO | The backup error code. | |||||||||||||||
| COMMENT | varchar2(4096) | YES | Description of the backup error code | |||||||||||||||
| ENCRYPTION_MODE | varchar2(64) | YES | Encryption mode:
Only None and Password are supported. |
|||||||||||||||
| PASSWD | varchar2(128) | YES | password | |||||||||||||||
| TENANT_COMPATIBLE | varchar2(4096) | NO | Tenant Version | |||||||||||||||
| BACKUP_COMPATIBLE | NUMBER(38) | NO | backup set version | |||||||||||||||
| PATH | varchar2(4096) | YES | Backup path | |||||||||||||||
| CLUSTER_VERSION | varchar(4096) | NO | The version number of the cluster. | |||||||||||||||
| CONSISTENT_SCN | NUMBER(38) | NO | Backup consistency SCN | |||||||||||||||
| MINOR_TURN_ID | NUMBER(38) | NO | The minor compaction round during which the dump was completed. | |||||||||||||||
| MAJOR_TURN_ID | NUMBER(38) | NO | Baseline backup end major turn |
Sample query
You can query the state of a standby cluster with the value of the BACKUP_SET_ID column as 1 in the current user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_BACKUP_SET_FILES WHERE BACKUP_SET_ID = 1\G
The query result is as follows:
*************************** 1. row ***************************
BACKUP_SET_ID: 1
DEST_ID: 1002
INCARNATION: 1
BACKUP_TYPE: FULL
PREV_FULL_BACKUP_SET_ID: 0
PREV_INC_BACKUP_SET_ID: 0
START_TIMESTAMP: 2024-05-10 14:02:04
END_TIMESTAMP: 2024-05-10 14:04:31
STATUS: SUCCESS
FILE_STATUS: AVAILABLE
ELAPSED_SECONDES: 147
PLUS_ARCHIVELOG: OFF
START_REPLAY_SCN: 1715320601793148000
START_REPLAY_SCN_DISPLAY: 10-MAY-24 01.56.41.793148000 PM
MIN_RESTORE_SCN: 1715321071272283000
MIN_RESTORE_SCN_DISPLAY: 2024-05-1014:04:31.272283000
INPUT_BYTES: 198413183
OUTPUT_BYTES: 20219996
OUTPUT_RATE_BYTES: 137125.4834937336727309530817741200907923
EXTRA_META_BYTES: 0
TABLET_COUNT: 657
FINISH_TABLET_COUNT: 657
MACRO_BLOCK_COUNT: 94
FINISH_MACRO_BLOCK_COUNT: 94
FILE_COUNT: 0
META_TURN_ID: 1
DATA_TURN_ID: 0
RESULT: 0
COMMENT: NULL
ENCRYPTION_MODE: NONE
PASSWD: NULL
TENANT_COMPATIBLE: 4.3.1.0
BACKUP_COMPATIBLE: 3
PATH: file:///home/admin/oceanbase/backupdataoracle
CLUSTER_VERSION: 4.3.1.0
CONSISTENT_SCN: 1715320960893795000
MINOR_TURN_ID: 1
MAJOR_TURN_ID: 1
1 row in set
References
View the history of backup jobs: DBA_OB_BACKUP_JOB_HISTORY
View the history of backup tasks: DBA_OB_BACKUP_TASK_HISTORY
For more information about how to view details about a data backup result, see View data backup results.