RECOVER STANDBY CANCEL

Purpose

When logs are being replayed for a standby tenant, you can use the ALTER SYSTEM RECOVER... CANCEL statement to cancel the log replay for the standby tenant.

Required privileges

You must execute this statement as the root user of the sys tenant (namely root@sys) or as the administrator of a user tenant.

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

Syntax

ALTER SYSTEM RECOVER STANDBY [TENANT [=] tenant_name] CANCEL;

Parameters

Examples

• Cancel log replay for the standby tenant restore_oracle_tenant from the sys tenant of the cluster where the standby tenant resides.

  obclient [oceanbase]> ALTER SYSTEM RECOVER STANDBY TENANT restore_oracle_tenant CANCEL;
  

• Cancel log replay for the standby tenant restore_oracle_tenant from the current tenant.

  obclient [SYS]> ALTER SYSTEM RECOVER STANDBY CANCEL;
  
  
  

## References

• Replay logs to a standby tenant

• Suspend or enable log synchronization