SET LOG_ARCHIVE_DEST_STATE

Purpose

The SET LOG_ARCHIVE_DEST_STATE statement is used to set the state of the archive destination.

Privilege requirements

It must be executed by the root user of the sys tenant (root@sys) or the administrator user of each tenant. Specifically:

• The default administrator user in MySQL-compatible mode is the root user.
• The default administrator user in Oracle-compatible mode is the SYS user.

Syntax

ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE={'ENABLE' | 'DEFER'} [TENANT = tenant_name];

Parameters

Examples

Assume that the tenant mysql_tenant has completed the configuration of the archiving destination. Example:

• The system tenant pauses log archiving for the mysql_tenant on the destination.

  obclient [oceanbase]> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE = 'DEFER' TENANT = mysql_tenant;
  

• The tenant mysql_tenant initiates log archiving for itself at the destination.

  obclient [oceanbase]> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE = 'ENABLE';
  

References

• SET LOG_ARCHIVE_DEST

• ARCHIVELOG

• Prepare for log archiving