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:

   • Execute the following statement in the sys tenant to clear the archive path setting for a specified tenant:

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

   • Execute the following statement in a user tenant to clear its archive path setting:

     obclient> ALTER SYSTEM SET LOG_ARCHIVE_DEST='';
     

References

• Disable ARCHIVELOG

• Preparations