Suspend archiving

After you enable ARCHIVELOG, you can change the archiving status at the archive destination to DEFER to suspend archiving.

Background information

The following table describes the archiving status at the archive destination.

Procedure

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

   Note

   The administrator user is root for a tenant in MySQL mode and SYS for a tenant in Oracle mode.

2. Suspend archiving at the archive destination.

   • Suspend archiving for a specified tenant from the sys tenant

     ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE='DEFER' TENANT = tenant_name;
     

   • Suspend archiving for the current user tenant

     ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE='DEFER';
     

3. Query the archiving status of the archive destination from a view. For more information, see View the archiving parameter settings.

What to do next

After archiving is suspended, you can re-enable archiving by setting the archiving status at the archive destination to ENABLE.

References

• View the archiving progress
• View the archiving history