Change the destination of log archiving

After log archiving is enabled, you can change the destination of log archiving as needed.

Considerations

The current implementation of automatic cleanup applies only to the backup destinations specified in DATA_BACKUP_DEST and the archive and backup destinations specified in LOG_ARCHIVE_DEST. If you change the log archive destination, data in the original archive path cannot be automatically cleaned up in OceanBase Database.

Procedure

1. Log in to the sys tenant or user tenant of the cluster as the tenant administrator.

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

3. Reconfigure the log archive destination.

   When you reconfigure the log archive destination, the directory that will become the new log archive destination must be empty. For more information about how to reconfigure the log archive destination, see the Specify the log archive destination section in Prepare for log archiving.

4. Query the LOG_ARCHIVE_DEST column in the CDB_OB_ARCHIVE_DEST view in the sys tenant or the DBA_OB_ARCHIVE_DEST view in the user tenant. For more information, see View log archiving parameters.

What to do next

After the log archive destination is changed, you must enable log archiving. For more information, see Enable log archiving.

References

• Disable log archiving

• Prepare for log archiving

• Enable log archiving