Purpose
You can use this statement to cancel ongoing range-based or continuous log replay for a standby tenant.
Required privileges
Only the root user of the sys tenant (root@sys) or the administrator user of a user tenant can execute this statement.
- The default administrator user in MySQL mode is
root. - The default administrator user in Oracle mode is
SYS.
Syntax
ALTER SYSTEM RECOVER STANDBY [TENANT [=] tenant_name] CANCEL;
Parameters
| Parameter | Description |
|---|---|
| tenant_name | The name of the standby tenant for which you want to cancel log replay. You can specify only one standby tenant at a time. If you want to specify multiple tenants, execute this statement repeatedly.
NoticeWhen you execute this statement in the |
Examples
In the
systenant of the cluster to which the standby tenantrestore_oracle_tenantbelongs, cancel log replay for the standby tenant.obclient [oceanbase]> ALTER SYSTEM RECOVER STANDBY TENANT restore_oracle_tenant CANCEL;In the standby tenant
restore_oracle_tenant, cancel log replay for the current tenant.obclient [SYS]> ALTER SYSTEM RECOVER STANDBY CANCEL;