During the restore of a tenant, you can execute the ALTER SYSTEM CANCEL RESTORE statement to stop the restore and delete the tenant to be restored.
Procedure
Log in as the
rootuser to thesystenant of the cluster to which the tenant to be restored belongs.Execute the following statement to immediately cancel the restore and delete the tenant to be restored:
ALTER SYSTEM CANCEL RESTORE tenant_name;Here,
tenant_nameis the name of the tenant for which data is to be restored.