CDB_OB_BACKUP_DELETE_JOBS
oceanbase.CDB_OB_BACKUP_DELETE_JOBS displays the progress of backup cleanup jobs that are being executed in all tenants.
Column |
Description |
|---|---|
| TENANT_ID | The ID of the tenant. |
| JOB_ID | The ID of the cleanup job. Job IDs are independent among tenants. |
| INCARNATION | The ID of the incarnation. |
| INITIATOR_TENANT_ID | The ID of the tenant from which the cleanup job is initiated. |
| INITIATOR_JOB_ID | The ID of the initiated cleanup job. |
| EXECUTOR_TENANT_ID | The list of IDs of tenants for which the cleanup job is executed. |
| TYPE | The cleanup type. Valid values:
|
| PARAMETER | The cleanup parameters, which describe the specific parameters for different cleanup types. |
| JOB_LEVEL | The job initiation level. Valid values:
|
| START_TIMESTAMP | The time on the tenant when the job started. |
| END_TIMESTAMP | The time on the tenant when the job ended. |
| STATUS | The job status. Valid values:
|
| TASK_COUNT | The total number of backup set and backup piece tasks. |
| SUCCESS_TASK_COUNT | The number of successful backup set and backup piece tasks. |
| RESULT | The execution result, which is an error code. |
| COMMENT | The description of a failed cleanup job. |
DBA_OB_BACKUP_DELETE_JOBS
oceanbase.DBA_OB_BACKUP_DELETE_JOBS displays the progress of backup cleanup jobs that are being executed in the current tenant.
Column |
Description |
|---|---|
| JOB_ID | The ID of the cleanup job. Job IDs are independent among tenants. |
| INCARNATION | The ID of the incarnation. |
| INITIATOR_TENANT_ID | The ID of the tenant from which the cleanup job is initiated. |
| INITIATOR_JOB_ID | The ID of the initiated cleanup job. |
| EXECUTOR_TENANT_ID | The list of IDs of tenants for which the cleanup job is executed. |
| TYPE | The cleanup type. Valid values:
|
| PARAMETER | The cleanup parameters, which describe the specific parameters for different cleanup types. |
| JOB_LEVEL | The job initiation level. Valid values:
|
| START_TIMESTAMP | The time on the tenant when the job started. |
| END_TIMESTAMP | The time on the tenant when the job ended. |
| STATUS | The job status. Valid values:
|
| TASK_COUNT | The total number of backup set and backup piece tasks. |
| SUCCESS_TASK_COUNT | The number of successful backup set and backup piece tasks. |
| RESULT | The execution result, which is an error code. |
| COMMENT | The description of a failed cleanup job. |
CDB_OB_BACKUP_DELETE_JOB_HISTORY
oceanbase.CDB_OB_BACKUP_DELETE_JOB_HISTORY displays the history of completed backup cleanup jobs of all tenants.
Column |
Description |
|---|---|
| TENANT_ID | The ID of the tenant. |
| JOB_ID | The ID of the cleanup job. Job IDs are independent among tenants. |
| INCARNATION | The ID of the incarnation. |
| INITIATOR_TENANT_ID | The ID of the tenant from which the cleanup job is initiated. |
| INITIATOR_JOB_ID | The ID of the initiated cleanup job. |
| EXECUTOR_TENANT_ID | The list of IDs of tenants for which the cleanup job is executed. |
| TYPE | The cleanup type. Valid values:
|
| PARAMETER | The cleanup parameters, which describe the specific parameters for different cleanup types. |
| JOB_LEVEL | The job initiation level. Valid values:
|
| START_TIMESTAMP | The time on the tenant when the job started. |
| END_TIMESTAMP | The time on the tenant when the job ended. |
| STATUS | The job status. Valid values:
|
| TASK_COUNT | The total number of backup set and backup piece tasks. |
| SUCCESS_TASK_COUNT | The number of successful backup set and backup piece tasks. |
| RESULT | The execution result, which is an error code. |
| COMMENT | The description of a failed cleanup job. |
DBA_OB_BACKUP_DELETE_JOB_HISTORY
oceanbase.DBA_OB_BACKUP_DELETE_JOB_HISTORY displays the history of completed backup cleanup jobs of the current tenant.
Column |
Description |
|---|---|
| JOB_ID | The ID of the cleanup job. Job IDs are independent among tenants. |
| INCARNATION | The ID of the incarnation. |
| INITIATOR_TENANT_ID | The ID of the tenant from which the cleanup job is initiated. |
| INITIATOR_JOB_ID | The ID of the initiated cleanup job. |
| EXECUTOR_TENANT_ID | The list of IDs of tenants for which the cleanup job is executed. |
| TYPE | The cleanup type. Valid values:
|
| PARAMETER | The cleanup parameters, which describe the specific parameters for different cleanup types. |
| JOB_LEVEL | The job initiation level. Valid values:
|
| START_TIMESTAMP | The time on the tenant when the job started. |
| END_TIMESTAMP | The time on the tenant when the job ended. |
| STATUS | The job status. Valid values:
|
| TASK_COUNT | The total number of backup set and backup piece tasks. |
| SUCCESS_TASK_COUNT | The number of successful backup set and backup piece tasks. |
| RESULT | The execution result, which is an error code. |
| COMMENT | The description of a failed cleanup job. |
CDB_OB_BACKUP_DELETE_TASKS
oceanbase.CDB_OB_BACKUP_DELETE_TASKS displays the progress of backup set and backup piece cleanup tasks that are being executed in all tenants.
Column |
Description |
|---|---|
| TENANT_ID | The ID of the tenant. |
| TASK_ID | The ID of the task. One task corresponds to the cleanup of one backup_set/backup_piece. |
| INCARNATION | The ID of the incarnation. |
| JOB_ID | The ID of the job to which the task belongs. |
| TASK_TYPE | The task type. Valid values:
|
| ID | The ID of the backup_set/backup_piece to be cleaned. |
| ROUND_ID | The round of log archiving to which the task belongs when the task type is BACKUP PIECE. |
| DEST_ID | The ID of the backup destination. |
| START_TIMESTAMP | The time on the tenant when the task started. |
| END_TIMESTAMP | The time on the tenant when the task ended. |
| STATUS | The task status. Valid values:
|
| TOTAL_TASK_COUNT | The total number of log streams under the task. |
| FINISH_TASK_COUNT | The number of log streams that are successfully cleaned. |
| RESULT | The task execution result, which is an error code. |
| COMMENT | The description of a failed cleanup task. |
| PATH | The path where the backup data is located. |
DBA_OB_BACKUP_DELETE_TASKS
oceanbase.DBA_OB_BACKUP_DELETE_TASKS displays the progress of backup set and backup piece cleanup tasks that are being executed in the current tenant.
Column |
Description |
|---|---|
| TASK_ID | The ID of the task. One task corresponds to the cleanup of one backup_set/backup_piece. |
| INCARNATION | The ID of the incarnation. |
| JOB_ID | The ID of the job to which the task belongs. |
| TASK_TYPE | The task type. Valid values:
|
| ID | The ID of the backup_set/backup_piece to be cleaned. |
| ROUND_ID | The round of log archiving to which the task belongs when the task type is BACKUP PIECE. |
| DEST_ID | The ID of the backup destination. |
| START_TIMESTAMP | The time on the tenant when the task started. |
| END_TIMESTAMP | The time on the tenant when the task ended. |
| STATUS | The task status. Valid values:
|
| TOTAL_TASK_COUNT | The total number of log streams under the task. |
| FINISH_TASK_COUNT | The number of log streams that are successfully cleaned. |
| RESULT | The task execution result, which is an error code. |
| COMMENT | The description of a failed cleanup task. |
| PATH | The path where the backup data is located. |
CDB_OB_BACKUP_DELETE_TASK_HISTORY
oceanbase.CDB_OB_BACKUP_DELETE_TASK_HISTORY displays the history of completed backup set and backup piece cleanup tasks of all tenants.
Column |
Description |
|---|---|
| TENANT_ID | The ID of the tenant. |
| TASK_ID | The ID of the task. One task corresponds to the cleanup of one backup_set/backup_piece. |
| INCARNATION | The ID of the incarnation. |
| JOB_ID | The ID of the job to which the task belongs. |
| TASK_TYPE | The task type. Valid values:
|
| ID | The ID of the backup_set/backup_piece to be cleaned. |
| ROUND_ID | The round of log archiving to which the task belongs when the task type is BACKUP PIECE. |
| DEST_ID | The ID of the backup destination. |
| START_TIMESTAMP | The time on the tenant when the task started. |
| END_TIMESTAMP | The time on the tenant when the task ended. |
| STATUS | The task status. Valid values:
|
| TOTAL_TASK_COUNT | The total number of log streams under the task. |
| FINISH_TASK_COUNT | The number of log streams that are successfully cleaned. |
| RESULT | The task execution result, which is an error code. |
| COMMENT | The description of a failed cleanup task. |
| PATH | The path where the backup data is located. |
DBA_OB_BACKUP_DELETE_TASK_HISTORY
oceanbase.DBA_OB_BACKUP_DELETE_TASK_HISTORY displays the history of completed backup set and backup piece cleanup tasks of the current tenant.
Column |
Description |
|---|---|
| TASK_ID | The ID of the task. One task corresponds to the cleanup of one backup_set/backup_piece. |
| INCARNATION | The ID of the incarnation. |
| JOB_ID | The ID of the job to which the task belongs. |
| TASK_TYPE | The task type. Valid values:
|
| ID | The ID of the backup_set/backup_piece to be cleaned. |
| ROUND_ID | The round of log archiving to which the task belongs when the task type is BACKUP PIECE. |
| DEST_ID | The ID of the backup destination. |
| START_TIMESTAMP | The time on the tenant when the task started. |
| END_TIMESTAMP | The time on the tenant when the task ended. |
| STATUS | The task status. Valid values:
|
| TOTAL_TASK_COUNT | The total number of log streams under the task. |
| FINISH_TASK_COUNT | The number of log streams that are successfully cleaned. |
| RESULT | The task execution result, which is an error code. |
| COMMENT | The description of a failed cleanup task. |
| PATH | The path where the backup data is located. |
CDB_OB_BACKUP_DELETE_POLICY
oceanbase.CDB_OB_BACKUP_DELETE_POLICY displays the backup cleanup policies that are in effect for all tenants.
Column |
Description |
|---|---|
| TENANT_ID | The ID of the tenant. |
| POLICY_NAME | The name of the cleanup policy. |
| RECOVERY_WINDOW | The time window within which backup data can be restored. |
DBA_OB_BACKUP_DELETE_POLICY
oceanbase.DBA_OB_BACKUP_DELETE_POLICY displays the backup cleanup policies that are in effect for the current tenant.
Column |
Description |
|---|---|
| POLICY_NAME | The name of the cleanup policy. |
| RECOVERY_WINDOW | The time window within which backup data can be restored. Default value: 0. |