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 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. Disable archiving at the archive destination.

   • Execute the following statement in the sys tenant to disable archiving at the archive destination for a specified tenant:

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

   • Execute the following statement in a user tenant to disable archiving at the archive destination for the 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