SET LOG_ARCHIVE_DEST_STATE

Purpose

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

Privilege requirements

This statement 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 mode is the root user.
• The default administrator user in Oracle mode is the SYS user.

Syntax

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

Parameters

Examples

Assume that the archive destination has been configured for the mysql_tenant tenant. Here are some examples:

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

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

• The mysql_tenant tenant starts log archiving at the archive destination.

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

References

• SET LOG_ARCHIVE_DEST

• ARCHIVELOG

• Preparation before log archiving