After you enable log archiving, you can change the log archive destination based on your business needs.
Limitations
If you use Amazon Simple Storage Service (S3) or an object storage service that is compatible with the S3 protocol as the archive destination type, the lag of log archiving, which is specified by the archive_lag_targe parameter, must be greater than or equal to 60 seconds. If you change the archive destination type from Alibaba Cloud Object Storage Service (OSS), Network File System (NFS), or Tencent Cloud Object Storage (COS) to S3 or an object storage service compatible with the S3 protocol, but the current value of the archive_lag_target parameter is smaller than 60 seconds, an error is returned after you execute the statement that changes the archive destination.
Procedure
Log on to the
systenant or a user tenant as the administrator.Disable log archiving. For more information, see Disable ARCHIVELOG.
Reconfigure the log archive destination.
Make sure that the directory where the new log archive destination belongs is empty. For more information about how to configure the log archive destination, see the Configure the archive destination section in Preparations.
Query the
CDB_OB_ARCHIVE_DESTview in thesystenant or theDBA_OB_ARCHIVE_DESTview in a user tenant for theLOG_ARCHIVE_DESTcolumn to verify whether the new log archive destination is successfully configured. For more information, see View the archiving parameter settings.
What to do next
After you change the log archive destination, you must enable log archiving again. For more information, see Enable ARCHIVELOG.