NOARCHIVELOG

Purpose

OceanBase Database supports archive (ARCHIVELOG) and non-archive (NOARCHIVELOG) modes for log archiving. You can use this statement to disable the archive mode for a user tenant.

Limitations and considerations

After you disable the archive mode for a tenant, the system automatically stops the ongoing and suspended archive jobs of the tenant.

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 NOARCHIVELOG [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 the archive mode has been enabled for the mysql_tenant and oracle_tenant tenants.

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

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

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

  obclient [oceanbase]> ALTER SYSTEM NOARCHIVELOG TENANT = mysql_tenant, oracle_tenant;
  

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

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

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

  obclient [oceanbase]> ALTER SYSTEM NOARCHIVELOG;
  

References

• SET LOG_ARCHIVE_DEST

• ARCHIVELOG

• Disable ARCHIVELOG