Clear the archive path setting

After log archiving stops, you can clear the archive path setting based on your business needs. Clearing the archive path setting does not delete any files from the path. If you want to use the path again, you can execute the SET LOG_ARCHIVE_DEST statement to specify the path as the archive path again.

Considerations

Before you clear the archive path setting, make sure that the archiving status of the tenant is STOP. For more information about how to query the archiving status, see View the archiving progress.

Procedure

1. Log in to the database as an administrator of the sys tenant or a user tenant.

   Note

   The administrator user is the root user in MySQL mode and the SYS user in Oracle mode.

2. Clear the archive path setting. Here are some examples:

   • Clear the archive path setting for a specified tenant in the sys tenant

     obclient> ALTER SYSTEM SET LOG_ARCHIVE_DEST='' TENANT = tenant_name;
     

   • Clear the archive path setting for a user tenant in the user tenant

     obclient> ALTER SYSTEM SET LOG_ARCHIVE_DEST='';
     

References

• Disable ARCHIVELOG

• Preparations