Stop clearing secondary backup data

This topic describes how to stop an ongoing secondary backup clearing task.

Stop manual clearing

The methods that you can use to stop manual secondary backup clearing for clusters and tenants are the same.

1. Log on to the sys tenant as the root user.

2. Execute the following statement to stop the ongoing clearing task:

   obclient> ALTER SYSTEM CANCEL DELETE BACKUP;
   

Stop automatic clearing

Before you stop an automatic secondary backup clearing task, disable automatic secondary backup clearing so that the task will not be scheduled again.

Note

Automatic secondary backup clearing can be implemented only at the cluster level.

1. Log on to the sys tenant as the root user.

2. Disable automatic secondary backup clearing.

   If you have enabled automatic secondary backup clearing by setting the backup_backup_dest_option parameter, change the value of auto_delete_obsolete_backup in backup_backup_dest_option to False. For more information about the auto_delete_obsolete_backup parameter in backup_backup_dest_option, see Preparations for secondary backup.

   If you have enabled automatic secondary backup clearing by setting the auto_delete_expired_backup parameter for your cluster, change the value of the parameter to False.

3. Execute the following statement to stop the ongoing clearing task:

   obclient> ALTER SYSTEM CANCEL DELETE BACKUP;
   

Verify whether a clearing task has been stopped

After the statement to stop the clearing task is executed, you can query the __all_virtual_backup_clean_info table to check whether the clearing task is stopped.

1. Log on to the sys tenant as the root user.

2. Execute the following statement to check whether the clearing task is stopped:

   obclient> SELECT tenant_id,status FROM oceanbase.__all_virtual_backup_clean_info;
   +-----------+--------+
   | tenant_id | status |
   +-----------+--------+
   |         1 | STOP   |
   |      1001 | STOP   |
   |      1002 | STOP   |
   +-----------+--------+
   3 rows in set
   

   If the value of status is STOP, the task is stopped.

More information

When you stop a secondary backup clearing task, you can attempt to force stop all backup-related tasks if the secondary backup clearing task is still running after the ALTER SYSTEM CANCEL DELETE BACKUP statement is executed. For more information, see Force stop all backup-related tasks.