Change the backup destination

After data backup is enabled, you can change the backup destination as needed.

Considerations

Automatic cleanup is supported only for backup destinations and archive destinations specified in the DATA_BACKUP_DEST or LOG_ARCHIVE_DEST parameter. If you change the backup destination, data in the original backup 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. Check whether any data backup tasks are in progress. For more information, see View the progress of data backup.

   If the result set is not empty, data backup is in progress. You must stop the backup task. For more information, see Stop a backup.

3. Reconfigure the backup destination.

   When you reconfigure the backup destination, the directory for the new backup destination must be empty. For more information about how to configure a backup destination, see Prepare for data backup.

4. Query the CDB_OB_BACKUP_PARAMETER view in the sys tenant or the DBA_OB_BACKUP_PARAMETER view in the user tenant to check whether the new backup destination is correctly configured. For more information, see View data backup parameters.

What to do next

After the backup destination is changed, initiate a full data backup. For more information, see Initiate a full data backup.

References

• View the progress of data backup

• Stop a backup

• Prepare for data backup

• Initiate a full data backup

• Initiate an incremental data backup