After you enable archiving mode, you can change the archiving status at the archive destination to DEFER to suspend archiving.
Background information
The following table describes the archiving statuses at the archive destination.
Status |
Description |
|---|---|
| ENABLE | Archiving is enabled at the archive destination. By default, the archive destination is in the ENABLE state. |
| DEFER | Archiving is suspended at the archive destination. If the archive destination is in this state, the system suspends any existing archiving jobs. |
Procedure
Log in to the database as the tenant administrator of the
systenant or a user tenant.Note
The administrator user of a user tenant is the
rootuser.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';
Query the archiving status of the archive destination from a view. For more information, 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.