Change the backup destination

After enabling data backup, you can change the backup destination based on your business needs.

Considerations

Since automatic cleanup currently only supports clearing data from the backup and archive destinations set in DATA_BACKUP_DEST and LOG_ARCHIVE_DEST, if you need to change the backup destination, the data in the original backup path will no longer be automatically cleaned up by OceanBase Database after the change.

Procedure

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

2. Check if any backup tasks are in progress. For detailed operations, see View the progress of a data backup.

   If the query result is not empty, it means there is a data backup in progress, and you need to stop the ongoing backup task. For detailed operations on stopping a backup task, see Stop a backup.

3. Reconfigure the backup destination.

   When reconfiguring the backup destination, if the directory to be replaced is a backup directory previously used by the tenant, the format file in that directory must exist. Otherwise, the directory to be replaced must be empty.

   For detailed operations on configuring the backup destination, see Prepare for backup.

4. After completing the above steps, query the CDB_OB_BACKUP_PARAMETER view (in the sys tenant) or the DBA_OB_BACKUP_PARAMETER view (in a user tenant) to confirm whether the new backup destination has been successfully configured. For detailed operations, see View data backup-related parameters.

What to do next

After the backup destination is successfully changed, you need to initiate a full data backup again. For detailed operations on initiating a full data backup, see Initiate a full data backup.

References

• View the progress of a data backup

• Stop a backup

• Prepare for backup

• Initiate a full data backup

• Initiate an incremental data backup