Stop a backup

This topic describes how to stop an ongoing backup task.

Stop a backup by using SQL statements

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

2. Execute the following statement to stop an ongoing data or log backup task.

   • Stop a data backup task.

     obclient> ALTER SYSTEM CANCEL BACKUP;
     

     Note

     The system resumes the data backup process if you initiate a data backup task again.

   • Stop a log backup task.

     obclient> ALTER SYSTEM NOARCHIVELOG;
     

Stop a backup in OCP

You can also stop data and log backup tasks in OceanBase Cloud Platform (OCP).

1. Log on to the OCP console.

2. In the left-side navigation pane, choose Backup & Recovery > Backup.

3. Perform the following steps to stop an ongoing data or log backup task.

   • On the Data Backup Tasks tab, find the cluster with the ongoing backup task, and click Stop in the Actions column.

   • On the Log Backup Tasks tab, find the cluster with the ongoing backup task, and click Stop in the Actions column.