Disable ARCHIVELOG

After you enable ARCHIVELOG for a tenant, you can disable ARCHIVELOG in the same way. After you disable ARCHIVELOG for a tenant, the system automatically stops the ongoing and suspended archiving jobs of the tenant.

Background information

Assume that the current cluster has three tenants: sys, mysql_tenant, and oracle_tenant, and that ARCHIVELOG is enabled for mysql_tenant and oracle_tenant.

Disable ARCHIVELOG for tenants from the sys tenant

You can disable ARCHIVELOG for all tenants or one or more specified tenants in the cluster from the sys tenant.

1. Log in to the sys tenant of the cluster as the root user.

2. Execute the following statement to disable ARCHIVELOG:

   • Disable ARCHIVELOG for all tenants in the cluster

     To disable ARCHIVELOG for all tenants in the cluster, execute the following statement:

     obclient [(none)]> ALTER SYSTEM NOARCHIVELOG [TENANT = ALL];
     

     In this example, ARCHIVELOG is disabled for the mysql_tenant and oracle_tenant tenants after the statement is executed. You can query the oceanbase.DBA_OB_TENANTS view from the sys tenant for the archiving modes of all tenants in the cluster.

     obclient [(none)]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE='USER'\G
     *************************** 1. row ***************************
     TENANT_NAME: mysql_tenant
        LOG_MODE: NOARCHIVELOG
     *************************** 2. row ***************************
     TENANT_NAME: oracle_tenant
        LOG_MODE: NOARCHIVELOG
     2 rows in set
     

   • Disable ARCHIVELOG for a specified tenant in the cluster

     To disable ARCHIVELOG for a specified tenant without affecting other tenants in the cluster, execute the following statement:

     obclient [(none)]> ALTER SYSTEM NOARCHIVELOG TENANT = mysql_tenant;
     

     Note

     If you specify multiple tenants, separate the tenant names with commas (,).

     In this example, only the mysql_tenant tenant enters the NOARCHIVELOG mode after you execute the statement. You can query the oceanbase.DBA_OB_TENANTS view from the tenant for the archiving modes of all tenants in the cluster.

     obclient [(none)]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = 'USER'\G
     *************************** 1. row ***************************
     TENANT_NAME: mysql_tenant
        LOG_MODE: NOARCHIVELOG
     *************************** 2. row ***************************
     TENANT_NAME: oracle_tenant
        LOG_MODE: ARCHIVELOG
     2 rows in set
     

Disable ARCHIVELOG for a user tenant from the current tenant

You can disable ARCHIVELOG for a user tenant from the current tenant without affecting other tenants.

1. Log in to the database as a tenant administrator.

   In this example, you can log in to the mysql_tenant tenant as the root user, or to the oracle_tenant tenant as the SYS user.

2. Execute the following statement to disable ARCHIVELOG:

   obclient [xxx]> ALTER SYSTEM NOARCHIVELOG;
   

   After the statement is executed, you can query the DBA_OB_TENANTS view from the tenant for its archiving mode.

   obclient [SYS]> SELECT TENANT_NAME, LOG_MODE FROM DBA_OB_TENANTS\G
   *************************** 1. row ***************************
   TENANT_NAME: oracle_tenant
      LOG_MODE: NOARCHIVELOG
   1 rows in set
   

References

• View the archiving progress
• View the archiving history