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 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 a 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.

Convert a standby tenant into primary tenant from the sys tenant

The procedure is as follows:

1. Log on 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 on 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;