Clear the archive path configuration

After log archiving stops, you can clear the archive path configuration as needed. Clearing the archive path configuration does not delete any files under the original archive path. After clearing the archive path configuration, if you need to use the original path again, you can configure the archive path to the original path again using the SET LOG_ARCHIVE_DEST command.

Considerations

Clearing the archive path configuration requires that the tenant's current archiving status is STOP. For the specific operations to view 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

   In MySQL-compatible mode, the administrator user is the root user, and in Oracle-compatible mode, the administrator user is the SYS user.

2. Execute the following commands to clear the archive path configuration:

   • System tenant clears the archive path configuration for the specified tenant

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

   • User tenant clears the archive path configuration for its own tenant

     obclient> ALTER SYSTEM SET LOG_ARCHIVE_DEST='';
     

References

• Disable ARCHIVELOG

• Prepare for log archiving