Convert a standby tenant into primary tenant

After a restore succeeded, the restored tenant is a standby tenant. You can execute the ACTIVATE STANDBY statement to convert the standby tenant into the primary tenant.

Background information

Physical restore is associated with the Physical Standby Database feature. A physically restored tenant serves as a standby tenant. You can convert it into the primary tenant based on your business needs.

Prerequisites

The restore succeeded. For more information about how to view the restore result, see View the restore result.

Limitations

This feature is not supported for quick restore.

Convert a standby tenant into primary tenant from the sys tenant

The procedure is as follows:

1. Log in to the sys tenant of the cluster as the root user.

2. Execute the following statement to change the role of the standby tenant:

   obclient [(none)]> ALTER SYSTEM ACTIVATE STANDBY TENANT tenant_name;
   

   Note

   You can use this statement to change the role of only one tenant at a time. To change the roles of multiple tenants, execute this statement repeatedly.

   Here is an example:

   obclient [(none)]> ALTER SYSTEM ACTIVATE STANDBY TENANT mysql;
   

   For more information about the parameters in the statement, see Parameters related to physical restore.

Convert a standby tenant into primary tenant from the user tenant

The procedure is as follows:

1. Log in to the database as an administrator of the standby tenant.

   Note

   The administrator user is root for a MySQL tenant and SYS for an Oracle tenant.

2. Execute the following statement to change the role of the standby tenant:

   obclient [(none)]> ALTER SYSTEM ACTIVATE STANDBY;