Change the backup destination during backup

After the backup has started, you can change the backup destination as needed.

Procedure

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

2. Run the following command to disable log backup.

   obclient> ALTER SYSTEM NOARCHIVELOG;
   

3. Run the following command to confirm that log backup is disabled.

   obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_ARCHIVELOG;
   

   Log backup is disabled when the value of status in the oceanbase.CDB_OB_BACKUP_ARCHIVELOG view turns to STOP.

4. Cancel ongoing baseline backup tasks, if any.

   1. Run the following command to check for ongoing backup tasks.

      obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_PROGRESS;
      

      You do not need to perform the cancellation operation if no backup task is in progress.

      Otherwise, proceed to the next step.

   2. Run the following command to cancel the ongoing backup tasks:

      obclient> ALTER SYSTEM CANCEL BACKUP;
      

   3. Run the following command again to confirm that all the ongoing backup task have been canceled.

      obclient> SELECT * FROM oceanbase.CDB_OB_BACKUP_PROGRESS;
      

5. Run the following command to change the backup destination.

   obclient> ALTER SYSTEM SET backup_dest= xxx;
   

   Replace xxx with the desired backup destination.

6. Initiate a new backup task. For more information, see Backup by using commands.