Change the destination of archiving

After you enable the log archiving mode, you can change the destination of archiving as needed.

Considerations

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

Procedure

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

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

3. Configure a new destination of archiving.

   The directory where the new archive destination resides must be empty. For more information about how to configure an archive destination, see the Configure an 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 to check whether the new archive destination is configured. For more information, see View archiving parameters.

What to do next

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

References

• Disable log archiving mode

• Prepare for log archiving

• Enable log archiving mode