Clear the archive path setting

After log archiving stops, you can clear the archive path setting as needed. Clearing the archive path setting does not delete any files from the original path. If you wish to reuse the path later, you can reconfigure it as the archive path using the SET LOG_ARCHIVE_DEST statement.

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