CANCEL DELETE BACKUP

Purpose

You can use this statement to cancel an ongoing backup cleanup job.

If you want to only cancel an ongoing backup cleanup job, you can execute the CANCEL DELETE BACKUP statement. If you want to cancel an ongoing backup cleanup job and make sure that it will not be scheduled again, you must execute the DROP DELETE BACKUP POLICY statement to drop the backup cleanup strategy and then execute the CANCEL DELETE BACKUP statement to cancel the job. For more information about the DROP DELETE BACKUP POLICY statement, see DELETE BACKUP POLICY.

Required privileges

Only the root user of the sys tenant (root@sys) or the administrator user of a user tenant can execute this statement.

• The default administrator user in MySQL mode is root.
• The default administrator user in Oracle mode is SYS.

Syntax

ALTER SYSTEM CANCEL DELETE BACKUP [TENANT [=] {tenant_name[, tenant_name]...} ];

Parameters

Examples

• In the sys tenant, drop the cleanup strategy default for the mysql_tenant tenant.

  obclient [oceanbase]> ALTER SYSTEM DROP DELETE BACKUP POLICY 'default' TENANT = mysql_tenant;
  

• In the sys tenant, cancel the ongoing backup cleanup jobs of the mysql_tenant and oracle_tenant tenants.

  obclient [oceanbase]> ALTER SYSTEM CANCEL DELETE BACKUP TENANT mysql_tenant, oracle_tenant;
  

• In the oracle_tenant tenant, cancel the ongoing backup cleanup job of the current tenant.

  obclient [SYS]> ALTER SYSTEM CANCEL DELETE BACKUP;
  

References

• DELETE BACKUP POLICY

• Stop backup cleanup