OceanBase Database allows you to query various views for monitoring the progress and results of backups.
CDB_OB_BACKUP_JOBS
The oceanbase.CDB_OB_BACKUP_JOBS view displays the progress of job-level data backup for each tenant.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that initiates the backup task. |
| JOB_ID | The ID of the job to which the backup task belongs. |
| INCARNATION | The incarnation ID. |
| BACKUP_SET_ID | The ID of the backup set. |
| INITIATOR_TENANT_ID | The ID of the tenant that initiates the job. |
| INITIATOR_JOB_ID | The ID of the job to which the initiating tenant belongs. |
| EXECUTOR_TENANT_ID | The ID of the tenant that needs to be backed up. |
| PLUS_ARCHIVELOG | Whether to enable the log padding function:
|
| BACKUP_TYPE | The type of backup. The possible values are as follows:
|
| JOB_LEVEL | The level at which the job is initiated. The possible values are as follows:
|
| ENCRYPTION_MOD | The encryption mode. The possible values are as follows:
|
| PASSWD | The encryption password of the backup set. |
| START_TIMESTAMP | The start time of the job-level backup task. |
| END_TIMESTAMP | The end time of the job-level backup task. |
| STATUS | The status of the backup task. |
| RESULT | The error code of the task. |
| COMMENT | The description of the error code. |
| DESCRIPTION | The user-specified description of the backup. |
| PATH | The backup path. |
CDB_OB_BACKUP_JOB_HISTORY
The oceanbase.CDB_OB_BACKUP_JOB_HISTORY view displays the historical information of job-level data backup for each tenant.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that performs the backup task. |
| JOB_ID | The ID of the job to which the backup task belongs. |
| INCARNATION | The ID of the incarnation. |
| BACKUP_SET_ID | The ID of the backup set. |
| INITIATOR_TENANT_ID | The ID of the tenant that initiates the job. |
| INITIATOR_JOB_ID | The ID of the job to which the initiating tenant belongs. |
| EXECUTOR_TENANT_ID | The ID of the tenant that needs to be backed up. |
| PLUS_ARCHIVELOG | Whether to enable the log padding function:
|
| BACKUP_TYPE | The type of backup. The possible values are as follows:
|
| JOB_LEVEL | The level at which the job is initiated. The possible values are as follows:
|
| ENCRYPTION_MOD | The encryption mode. The possible values are as follows:
Currently, only None and Password are supported. |
| PASSWD | The encryption password of the backup set. |
| START_TIMESTAMP | The start time of the job-level backup task. |
| END_TIMESTAMP | The end time of the job-level backup task. |
| STATUS | The status of the backup task. |
| RESULT | The error code of the task. |
| COMMENT | The description of the error code. |
| DESCRIPTION | The user-specified description of the backup. |
| PATH | The backup path. |
CDB_OB_BACKUP_TASKS
The oceanbase.CDB_OB_BACKUP_TASKS view displays the progress of task-level data backup tasks for each tenant.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that initiates the backup task. |
| TASK_ID | The ID of the task-level backup task, which corresponds to a backup set. |
| JOB_ID | The ID of the job to which the task-level backup task belongs, namely, a backup task. |
| INCARNATION | The incarnation ID. |
| BACKUP_SET_ID | The ID of the backup set corresponding to the task. |
| START_TIMESTAMP | The start time of the task. |
| END_TIMESTAMP | The end time of the task. |
| STATUS | The status of the backup task. |
| START_SCN | The start SCN of the backup task. |
| END_SCN | The end SCN of the backup task. |
| USER_LS_START_SCN | The start SCN of the user log stream. |
| ENCRYPTION_MODE | The encryption mode.
Currently, only None and Password modes are supported. |
| PASSWD | The encryption password of the backup set. |
| INPUT_BYTES | The number of input bytes. |
| OUTPUT_BYTES | The number of output bytes. |
| OUTPUT_RATE_BYTES | The output rate. |
| EXTRA_META_BYTES | The additional metadata bytes. |
| TABLET_COUNT | The total number of tablets. |
| FINISH_TABLET_COUNT | The number of tablets that have been backed up. |
| MACRO_BLOCK_COUNT | The total number of macroblocks. |
| FINISH_MACRO_BLOCK_COUNT | The number of macroblocks that have been backed up. |
| FILE_COUNT | The total number of files. |
| META_TURN_ID | The metadata backup round. |
| DATA_TURN_ID | The data backup round. |
| RESULT | The error code. |
| COMMENT | The description of the error code. |
| PATH | The backup path information. |
| MINOR_TURN_ID | The minor data backup round. |
| MAJOR_TURN_ID | The major data backup round. |
| DATA_PROGRESS | The data backup progress. It is calculated as number of macroblocks backed up / total number of macroblocks. The result is retained to two decimal places. For example, 87.65 indicates that the current progress is 87.65%. |
CDB_OB_BACKUP_TASK_HISTORY
The oceanbase.CDB_OB_BACKUP_TASK_HISTORY view displays historical information about data backup tasks at the task level for each tenant.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that initiates the backup task. |
| TASK_ID | The ID of the task-level backup task, which corresponds to a backup set. |
| JOB_ID | The ID of the job to which the task-level backup task belongs, namely, a backup task. |
| INCARNATION | The incarnation ID. |
| BACKUP_SET_ID | The ID of the backup set corresponding to the task. |
| START_TIMESTAMP | The start time of the task. |
| END_TIMESTAMP | The end time of the task. |
| STATUS | The status of the task. |
| START_SCN | The start SCN of the backup task. |
| END_SCN | The end SCN of the backup task. |
| USER_LS_START_SCN | The start SCN of user log streams. |
| ENCRYPTION_MODE | The encryption mode.
At present, only None and Password modes are supported. |
| PASSWD | The encryption password of the backup set. |
| INPUT_BYTES | The number of input bytes. |
| OUTPUT_BYTES | The number of output bytes. |
| OUTPUT_RATE_BYTES | The output rate. |
| EXTRA_META_BYTES | The additional metadata bytes. |
| TABLET_COUNT | The total number of tablets. |
| FINISH_TABLET_COUNT | The number of completed tablets. |
| MACRO_BLOCK_COUNT | The total number of macroblocks. |
| FINISH_MACRO_BLOCK_COUNT | The number of completed macroblocks. |
| FILE_COUNT | The total number of files. |
| META_TURN_ID | The metadata backup round. |
| DATA_TURN_ID | The data backup round. |
| RESULT | The error code. |
| COMMENT | The error code description. |
| PATH | The backup path information. |
| MINOR_TURN_ID | The minor data backup round that ends. |
| MAJOR_TURN_ID | The major baseline data backup round that ends. |
CDB_OB_BACKUP_SET_FILES
The oceanbase.CDB_OB_BACKUP_SET_FILES view displays information about the backup sets of each tenant.
| Column | Description |
|---|---|
| TENANT_ID | The ID of the tenant that performs the backup task. |
| BACKUP_SET_ID | The ID of the backup set. |
| DEST_ID | The ID of the path. |
| INCARNATION | The incarnation ID. |
| BACKUP_TYPE | The type of backup. |
| PREV_FULL_BACKUP_SET_ID | The ID of the preceding full backup set that the current backup set depends on. |
| PREV_INC_BACKUP_SET_ID | The ID of the preceding incremental backup set that the current backup set depends on. |
| START_TIMESTAMP | The start timestamp of the backup. |
| END_TIMESTAMP | The end timestamp of the backup. |
| STATUS | The status of the backup set. The possible values are:
|
| FILE_STATUS | The status of the files in the backup set. |
| ELAPSED_SECONDES | The duration of the backup in seconds. |
| PLUS_ARCHIVELOG | Whether to include archivelog. |
| START_REPLAY_SCN | The start SCN of the logs that the backup set depends on. |
| START_REPLAY_SCN_DISPLAY | The timestamp corresponding to the start SCN of the logs that the backup set depends on. |
| MIN_RESTORE_SCN | The minimum SCN of the restore point. |
| MIN_RESTORE_SCN_DISPLAY | The timestamp corresponding to the minimum SCN of the restore point. |
| INPUT_BYTES | The number of input bytes. |
| OUTPUT_BYTES | The number of output bytes. |
| OUTPUT_RATE_BYTES | The output rate. |
| EXTRA_META_BYTES | The number of additional metadata bytes. |
| TABLET_COUNT | The total number of tablets. |
| FINISH_TABLET_COUNT | The number of tablets that have been backed up. |
| MACRO_BLOCK_COUNT | The total number of macroblocks. |
| FINISH_MACRO_BLOCK_COUNT | The number of macroblocks that have been backed up. |
| FILE_COUNT | The total number of files. |
| META_TURN_ID | The metadata backup round. |
| DATA_TURN_ID | The data backup round. |
| RESULT | The error code. |
| COMMENT | The error code description. |
| ENCRYPTION_MODE | The encryption mode. The possible values are:
Currently, only the None and Password modes are supported. |
| PASSWD | The password of the backup set. |
| TENANT_COMPATIBLE | The tenant version number. |
| BACKUP_COMPATIBLE | The backup set version number. |
| PATH | The backup path. |
| CLUSTER_VERSION | The cluster version number. |
| CONSISTENT_SCN | The consistency SCN of the backup. |
| MINOR_TURN_ID | The round when minor data backup is completed. |
| MAJOR_TURN_ID | The round when baseline data backup is completed. |