Operations related to secondary backup

Switch the destination of secondary backup

If problems exist with the media (such as OSS) for secondary backup, OceanBase Database supports switching to another backup destination.

Perform the following operations to switch the destination of secondary backup:

1. Stop the automatic secondary backup of logs.

   Example:

   obclient> ALTER SYSTEM STOP BACKUP ARCHIVELOG;
   

2. Stop the secondary backup of data.

   Example:

   obclient> ALTER SYSTEM CANCEL BACKUP BACKUPSET;
   

3. Set a new destination for secondary backup.

   Example:

   obclient> ALTER SYSTEM SET backup_backup_dest='xxxxx';
   

   In the command, replace xxxxx with the new secondary backup destination.

4. Restart the worker thread of secondary backup.

   Example:

   1. Set the interval for the worker thread of secondary backup.

      backup_backup_dest_option specifies parameters related to secondary backup. For more information about backup_backup_dest_option, see the "backup_backup_dest_option" topic in Reference Guide (MySQL Mode) or Reference Guide (Oracle Mode).

      obclient> ALTER SYSTEM SET backup_backup_dest_option = 'log_archive_checkpoint_interval='1h';
      

   2. Start the worker thread of secondary backup.

      obclient> ALTER SYSTEM BACKUP BACKUPSET ALL;
      

View the status of secondary backup

After the worker thread of secondary backup is started, you can learn the status of secondary backup by using the following views:

• oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB

• oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY

• oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK

• oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY

• oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY

For more information about the fields in these views, see Reference Guide (MySQL Mode).