DELETE OBSOLETE BACKUP

The DELETE OBSOLETE BACKUP statement is used to manually trigger the cleanup of expired backups.

Limitations

• When the sys tenant executes the DELETE OBSOLETE BACKUP statement, if a user tenant is specified, the specified user tenant must have a cleanup strategy set. If no user tenant is specified, all user tenants must have automatic cleanup strategies set.

• When a user tenant executes the DELETE OBSOLETE BACKUP statement, the current user tenant must have an automatic cleanup strategy set.

For more information about setting an automatic cleanup strategy, see DELETE BACKUP POLICY.

Privilege requirements

The statement must be executed by the root user of the sys tenant (root@sys) or the administrator user of each tenant. Specifically:

• In MySQL mode, the default administrator user is root.
• In Oracle mode, the default administrator user is SYS.

Syntax

ALTER SYSTEM DELETE OBSOLETE BACKUP [TENANT [=] tenant_name]; 

Parameters

Examples

• For the sys tenant

  • Trigger the cleanup of expired backups for the mysql001 tenant.

    obclient(root@sys)[(none)]> ALTER SYSTEM DELETE OBSOLETE BACKUP TENANT mysql001;
    

  • Trigger the cleanup of expired backups for all user tenants.

    obclient(root@sys)[(none)]> ALTER SYSTEM DELETE OBSOLETE BACKUP;
    

• For a user tenant

  Trigger the cleanup of expired backups for the current tenant.

  obclient> ALTER SYSTEM DELETE OBSOLETE BACKUP;
  

References

• DELETE BACKUP POLICY

• CANCEL DELETE BACKUP

• Automatic cleanup of expired backups

• Manual cleanup of expired backups

• Cancel a cleanup task