DELETE BACKUP

You can use statements in this topic to automatically delete expired backups, drop backup deletion strategies, and cancel backup deletion tasks. Both the sys tenant and user tenants support backup deletion operations.

For more information about data backup operations in OceanBase Database, see Backup and restore in Manage.

Syntax

Automatically delete expired backups

/* Set a backup deletion strategy for a specified tenant in the sys tenant. */
ALTER SYSTEM ADD DELETE BACKUP POLICY policy_name RECOVERY_WINDOW recovery_window TENANT tenant_name;

/* Set a backup deletion strategy for the current user tenant. */
ALTER SYSTEM ADD DELETE BACKUP POLICY policy_name RECOVERY_WINDOW recovery_window;

Drop a backup deletion strategy

/* Drop a backup deletion strategy for a specified tenant in the sys tenant. */
ALTER SYSTEM DROP DELETE BACKUP POLICY policy_name TENANT tenant_name;

/* Drop a backup deletion strategy for the current user tenant. */
ALTER SYSTEM DROP DELETE BACKUP POLICY policy_name;

Cancel a backup deletion task

/* Cancel the ongoing backup deletion task for a specified tenant in the sys tenant. If you do not specify the TENANT parameter, the ongoing backup deletion tasks of all user tenants are canceled.  */
 ALTER SYSTEM CANCEL DELETE BACKUP [TENANT tenant_name_list];

/* Cancel the ongoing backup deletion task for the current user tenant. */
ALTER SYSTEM CANCEL DELETE BACKUP;

Parameters

Examples

• In the sys tenant, set the backup deletion strategy to default and the time window in which backups are restorable to 7 days for the MySQL tenant.

  obclient> ALTER SYSTEM ADD DELETE BACKUP POLICY 'default' RECOVERY_WINDOW '7d' TENANT MySQL;
  

• In a user tenant, set the backup deletion strategy to default and the time window in which backups are restorable to 7 days for the current tenant.

  obclient> ALTER SYSTEM ADD DELETE BACKUP POLICY 'default' RECOVERY_WINDOW '7d';
  

• In the sys tenant, drop the backup deletion strategy named default for the MySQL tenant.

  obclient> ALTER SYSTEM DROP DELETE BACKUP POLICY 'default' TENANT MySQL;
  

• In the sys tenant, cancel the ongoing backup deletion tasks for the MySQL and Oracle tenants.

  obclient> ALTER SYSTEM CANCEL DELETE BACKUP TENANT MySQL, Oracle;