Suspend or enable log synchronization

During log synchronization for a standby tenant, you can suspend and resume log synchronization.

Suspend log synchronization

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

2. Suspend log synchronization.

   ALTER SYSTEM RECOVER STANDBY [TENANT = tenant_name] CANCEL ;
   

   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.

   The following sample code suspends log synchronization for the standby tenant in the sys tenant:

   ALTER SYSTEM RECOVER STANDBY TENANT = standby_tenant CANCEL ;
   

   Execute the following statement a standby tenant to suspend log synchronization for the standby tenant:

   ALTER SYSTEM RECOVER STANDBY CANCEL;
   

   Notice

   After you suspend log synchronization, the standby tenant no longer synchronizes logs from the primary tenant. This can interrupt log streams of the standby tenant. Proceed with caution.

3. Query the synchronization progress of log streams from the DBA_OB_TENANTS and GV$OB_LOG_STAT views. The progress stops at the point in time at which the statement was executed.

   For more information, see View the log synchronization progress.

Enable log synchronization

After you suspend log synchronization for a standby tenant, you can resume log synchronization by changing the restore end point for the standby tenant.

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

2. Enable log synchronization.

   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 enable log synchronization for the specified standby tenant:

   ALTER SYSTEM RECOVER STANDBY TENANT = standby_tenant UNTIL UNLIMITED;
   

   Execute the following statement in the standby tenant to enable log synchronization for the standby tenant:

   ALTER SYSTEM RECOVER STANDBY UNTIL UNLIMITED;
   

References

View the log synchronization progress