Change the log archive destination

After you enable log archiving, you can change the log archive destination based on your business needs.

Limitations

When using AWS S3 as the archiving medium, ensure that the archive lag time (controlled by the archive_lag_target parameter) is set to 60 seconds or longer. If the value of archive_lag_target is smaller than 60 seconds when switching from archiving media such as OSS, NFS, or COS to S3, an attempt to execute the command to modify the archiving destination will lead to an error.

Procedure

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

2. Disable log archiving. For more information, see Disable ARCHIVELOG.

3. 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.

4. Query the CDB_OB_ARCHIVE_DEST view in the sys tenant or the DBA_OB_ARCHIVE_DEST view in a user tenant for the LOG_ARCHIVE_DEST column 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.

References

• Disable ARCHIVELOG

• Preparations

• Enable ARCHIVELOG