Purpose
You can use the ALTER SYSTEM CANCEL RESTORE statement to cancel an ongoing tenant restore job and delete the tenant being restored.
Required privileges
You can execute the ALTER SYSTEM CANCEL RESTORE statement only as the root user of the sys tenant (namely root@sys).
Syntax
ALTER SYSTEM CANCEL RESTORE dest_tenant_name;
Parameters
| Parameter | Description |
|---|---|
| dest_tenant_name | The name of the tenant for which the restore is to be canceled. |
Examples
Cancel the ongoing restore of the mysql tenant.
obclient [oceanbase]> ALTER SYSTEM CANCEL RESTORE mysql;