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