Other issues

Failure to specify a log restore source for a standby tenant

Symptom

When you specify a log restore source for a standby tenant in the network-based Physical Standby Database architecture, the client returns the following error message: set tenant itself as log restore source is not allowed.

Possible causes

To prevent you from specifying the current tenant as the restore source when you specify a log restore source for a network-based standby tenant or create an empty network-based standby tenant, at least one of the cluster_id and tenant_id values of the primary tenant must be different that of the standby tenant. Otherwise, the preceding error message will be returned.

Solution

• If the primary and standby tenants belong to the same cluster, check whether the current tenant is specified in the statement to specify the log restore source.

• If the primary and standby tenants belong to different clusters, verify the tenant information and check whether the cluster_id values of the clusters are the same. The cluster_id value of an OceanBase cluster deployed using OceanBase Cloud Platform (OCP) or OceanBase Deployer (obd) is unique, but that of a manually deployed OceanBase cluster may not be unique.