Specify a log restore end point

By default, the standby tenant should be in continuous synchronization mode. If not, enable the continuous synchronization mode for the standby tenant.

Procedure

1. Log on as the administrator to the standby tenant or the sys tenant of the cluster where the standby tenant resides.

2. Execute the RECOVER statement to specify a log restore end point for the standby tenant.

   ALTER SYSTEM RECOVER STANDBY [TENANT = tenant_name] UNTIL UNLIMITED;
   

   You need to add the TENANT = tenant_name parameter to the statement to specify the name of the standby tenant only when you execute the statement in the sys tenant. UNLIMITED indicates that the end point is infinite.

   Execute the following statement in the sys tenant to specify the log restore end point for the standby tenant:

   ALTER SYSTEM RECOVER STANDBY TENANT = standby_tenant UNTIL UNLIMITED;
   

   Execute the following statement in the standby tenant to specify the log restore end point for the standby tenant:

   ALTER SYSTEM RECOVER STANDBY UNTIL UNLIMITED;
   

   After you execute this statement, the standby tenant enters the continuous synchronization mode.

More information

OceanBase Database also allows you to execute the RECOVER statement to set the restore end point for the standby tenant to any appropriate point in time. The syntax is as follows:

• Restore the log to a specified timestamp

  ALTER SYSTEM RECOVER STANDBY [TENANT = tenant_name] UNTIL TIME='timestamp';
  

• Restore the log to a specified system change number (SCN)

  ALTER SYSTEM RECOVER STANDBY [TENANT = tenant_name] UNTIL SCN =scn;
  

The parameters are described as follows:

• You need to add the TENANT = tenant_name parameter to the statement to specify the name of the standby tenant only when you execute the statement in the sys tenant.

• timestamp specifies a timestamp in nanoseconds.

• scn specifies a logical and internal system timestamp.

The preceding statement restores the standby tenant to the specified timestamp.

References

• Create a standby tenant by using the backup and recovery feature

• Create a standby tenant by using the BACKUP DATABASE PLUS ARCHIVELOG feature