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 a specified tenant 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

     This method disables ARCHIVELOG for all tenants in the cluster.

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

     After the statement is executed, ARCHIVELOG is disabled for the mysql_tenant and oracle_tenant tenants in this example. You can query the oceanbase.DBA_OB_TENANTS view in 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

     This method disables ARCHIVELOG only for the specified tenant and does not affect other tenants in the cluster.

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

     Note

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

     After the statement is successfully executed, in this example, ARCHIVELOG is disabled for mysql_tenant. You can query the oceanbase.DBA_OB_TENANTS view in 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 log in 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 successfully executed, you can directly query the DBA_OB_TENANTS view in this 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