Change the destination of log archiving

After you enable the log archiving mode, you can change the destination of log archiving based on your business requirements.

Considerations

The automatic cleanup feature applies only to the backup destination specified by DATA_BACKUP_DEST and the archiving destination specified by LOG_ARCHIVE_DEST. If you change the log archiving destination, the data in the original archiving path cannot be automatically cleaned up by OceanBase Database.

Procedure

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

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

3. Configure a new log archiving destination.

   When you configure a new log archiving destination, make sure that the directory specified for the new destination is empty. For more information about how to configure a log archiving destination, see the Configure an archiving destination section in Prepare for log archiving.

4. Query the LOG_ARCHIVE_DEST column of the CDB_OB_ARCHIVE_DEST view in the sys tenant or the LOG_ARCHIVE_DEST column of the DBA_OB_ARCHIVE_DEST view in the user tenant to check whether the new log archiving destination is configured. For more information, see View log archiving parameters.

What to do next

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

References

• Disable log archiving

• Prepare for log archiving

• Enable log archiving