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

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

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. After the configuration succeeds, you can query the view to check the status of the archive destination. For the specific operations, see View archive parameters.

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