Views related to backup cleanup|V4.1.0| docs|Distributed Database

Views related to backup cleanup

Last Updated：2023-07-28 02:55:42 Updated

CDB_OB_BACKUP_DELETE_JOBS

You can query this view from the sys tenant for the progress of ongoing backup cleanup jobs of all tenants.

Field	Description
TENANT_ID	The ID of the tenant.
JOB_ID	The ID of the executed 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. `DELETE OBSOLETE BACKUP`: specifies to clean expired backup data.
PARAMETER	The cleanup parameter that specifies the expiration time of the cleanup job.
JOB_LEVEL	The job initiation level. Valid values: `USER_TENANT`: The job is initiated by a user tenant. `SYS_TENANT`: The job is initiated by the sys tenant.
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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The job is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
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 task.

DBA_OB_BACKUP_DELETE_JOBS

You can query this view from a user tenant for the progress of ongoing backup cleanup jobs of the tenant.

Field	Description
JOB_ID	The ID of the executed 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. `DELETE OBSOLETE BACKUP`: specifies to clean expired backup data.
PARAMETER	The cleanup parameter that specifies the expiration time of the cleanup job.
JOB_LEVEL	The job initiation level. Valid values: `USER_TENANT`: The job is initiated by a user tenant. `SYS_TENANT`: The job is initiated by the sys tenant.
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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The job is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
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 task.

CDB_OB_BACKUP_DELETE_JOB_HISTORY

You can query this view from the sys tenant for the history of completed backup cleanup jobs of all tenants.

Field	Description
TENANT_ID	The ID of the tenant.
JOB_ID	The ID of the executed 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. `DELETE OBSOLETE BACKUP`: specifies to clean expired backup data.
PARAMETER	The cleanup parameter that specifies the expiration time of the cleanup job.
JOB_LEVEL	The job initiation level. Valid values: `USER_TENANT`: The job is initiated by a user tenant. `SYS_TENANT`: The job is initiated by the sys tenant.
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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The job is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
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 task.

DBA_OB_BACKUP_DELETE_JOB_HISTORY

You can query this view from a user tenant for the history of completed backup cleanup jobs of the tenant.

Field	Description
JOB_ID	The ID of the executed 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. `DELETE OBSOLETE BACKUP`: specifies to clean expired backup data.
PARAMETER	The cleanup parameter that specifies the expiration time of the cleanup job.
JOB_LEVEL	The job initiation level. Valid values: `USER_TENANT`: The job is initiated by a user tenant. `SYS_TENANT`: The job is initiated by the sys tenant.
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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The job is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
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 task.

CDB_OB_BACKUP_DELETE_TASKS

You can query this view from the sys tenant for the progress of ongoing backup set/backup piece cleanup tasks of all tenants.

Field	Description
TENANT_ID	The ID of the tenant.
TASK_ID	The task ID. One task corresponds to one backup set or 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: `BACKUP SET`: a backup set cleanup task `BACKUP PIECE`: a backup piece cleanup task
ID	The ID of the backup set or backup piece to be cleaned.
ROUND_ID	The round of log archiving 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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The task is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
TOTAL_LS_COUNT	The total number of log streams under the task.
FINISH_LS_COUNT	The number of successful log stream tasks.
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

You can query this view from a user tenant for the progress of ongoing backup set/backup piece cleanup tasks of the tenant.

Field	Description
TASK_ID	The task ID. One task corresponds to one backup set or 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: `BACKUP SET`: a backup set cleanup task `BACKUP PIECE`: a backup piece cleanup task
ID	The ID of the backup set or backup piece to be cleaned.
ROUND_ID	The round of log archiving 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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The task is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
TOTAL_LS_COUNT	The total number of log streams under the task.
FINISH_LS_COUNT	The number of successful log stream tasks.
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

You can query this view from the sys tenant for the history of completed backup set/backup piece cleanup tasks of all tenants.

Field	Description
TENANT_ID	The ID of the tenant.
TASK_ID	The task ID. One task corresponds to one backup set or 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: `BACKUP SET`: a backup set cleanup task `BACKUP PIECE`: a backup piece cleanup task
ID	The ID of the backup set or backup piece to be cleaned.
ROUND_ID	The round of log archiving 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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The task is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
TOTAL_LS_COUNT	The total number of log streams under the task.
FINISH_LS_COUNT	The number of successful log stream tasks.
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

You can query this view from a user tenant for the history of completed backup set/backup piece cleanup tasks of the tenant.

Field	Description
TASK_ID	The task ID. One task corresponds to one backup set or 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: `BACKUP SET`: a backup set cleanup task `BACKUP PIECE`: a backup piece cleanup task
ID	The ID of the backup set or backup piece to be cleaned.
ROUND_ID	The round of log archiving 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: `INIT`: The task is in the initialization state. `DOING`: The task is being executed. `CANCELING`: The task is being canceled. `COMPLETED`: The task is executed. `FAILED`: The task failed. `CANCELED`: The task is canceled.
TOTAL_LS_COUNT	The total number of log streams under the task.
FINISH_LS_COUNT	The number of successful log stream tasks.
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

You can query this view from the sys tenant for information about in-effect backup cleanup strategies of all tenants.

Field	Description
TENANT_ID	The ID of the tenant.
POLICY_NAME	The name of the cleanup strategy.
RECOVERY_WINDOW	The restorable window.

DBA_OB_BACKUP_DELETE_POLICY

You can query this view from a user tenant for information about in-effect backup cleanup strategies of the tenant.

MySQL mode

Field	Description
POLICY_NAME	The name of the cleanup strategy.
RECOVERY_WINDOW	The restorable window. Default value: `0`.

Oracle mode

Field	Description
POLICY_NAME	The name of the cleanup strategy.
RECOVERY_WINDOW	The restorable window. Default value: `0`.