CANCEL VALIDATE

Purpose

The ALTER SYSTEM CANCEL VALIDATE statement is used to cancel a running backup validation task.

Limitations

Starting from V4.4.2 BP2, the ALTER SYSTEM CANCEL VALIDATE statement is supported in OceanBase Database V4.4.2.

Privilege requirements

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

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

Syntax

ALTER SYSTEM CANCEL VALIDATE BACKUP [TENANT = mysql_tenant];

Parameters

Examples

• The system tenant cancels the backup verification task being executed by the user.

  • The system tenant cancels the backup verification tasks for all user tenants.

    obclient(root@sys)[(none)]> ALTER SYSTEM CANCEL VALIDATE BACKUP;
    

  • The system tenant cancels the backup verification task for the specified user tenant mysqltenant.

    obclient(root@sys)[(none)]> ALTER SYSTEM CANCEL VALIDATE BACKUP TENANT = mysqltenant;
    

• Cancel a backup verification task being executed by the current tenant.

  obclient> ALTER SYSTEM CANCEL VALIDATE BACKUP;
  

References

• Overview of backup verification

• View backup verification progress

• View backup verification results