ARCHIVELOG

Purpose

OceanBase Database supports archive (ARCHIVELOG) and non-archive (NOARCHIVELOG) modes for log archiving. You can use this statement to enable the archive mode for a user tenant. You can initiate a log archive job for a tenant only when the tenant is in archive mode.

You can use the ALTER SYSTEM NOARCHIVELOG statement to disable the archive mode. For more information about this statement, see NOARCHIVELOG.

Required privileges

Only the root user of the sys tenant (root@sys) or the administrator user of a user tenant can execute this statement.

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

Syntax

ALTER SYSTEM ARCHIVELOG [TENANT = {all | tenant_name[, tenant_name...]}] [DESCRIPTION [=] 'description'];

Parameters

Examples

Assume that the current cluster contains three tenants: sys, mysql_tenant, and oracle_tenant, and that archive destinations have been configured for the mysql_tenant and oracle_tenant tenants.

• In the sys tenant, enable the archive mode for the mysql_tenant tenant.

  obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG TENANT = mysql_tenant;
  

• In the sys tenant, enable the archive mode for the mysql_tenant and oracle_tenant tenants.

  obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG TENANT = mysql_tenant;
  

• In the sys tenant, enable the archive mode for all user tenants.

  obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG TENANT = all;
  

• In the mysql_tenant or oracle_tenant tenant, enable the archive mode for the current tenant.

  obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG;
  

References

• SET LOG_ARCHIVE_DEST

• NOARCHIVELOG

• Enable ARCHIVELOG