DELETE BACKUPSET/ARCHIVELOG_PIECE

The DELETE BACKUPSET/ARCHIVELOG_PIECE statement is used to clean up specified data backup sets or log archive pieces.

Limitations and considerations

• When using the DELETE BACKUPSET statement to clean up specified data backup sets, the following considerations apply:

  • Do not disrupt the dependencies between data backups. If a data backup is depended on by an incremental backup, the dependent data backup can only be deleted after all incremental backups that depend on it have been deleted.

  • If multiple backup_set_id values are to be specified for cleanup, all backup_set_id values must be in the same backup path. It is not supported to clean up data backups from multiple paths in a single command.

  • For the currently used backup path, at least one latest and restorable full data backup must be retained. That is, a restorable full backup must be retained before deleting other backup sets prior to it.

  • If the data backup set to be deleted is not in the currently used backup path, ensure that OceanBase Database has access permissions for the corresponding backup path.

• When using the DELETE ARCHIVELOG_PIECE statement to clean up specified log archive pieces, the following considerations apply:

  • Log archive pieces must be cleaned up in order.

  • When cleaning up pieces in the current archive path, the cleaned-up piece must not be depended on by any data backup in the current data backup path.

  • If multiple piece_id values are to be specified for cleanup, all piece_id values must be in the same archive path. It is not supported to clean up log archive pieces from multiple paths in a single command.

Privilege requirements

The statement must be executed by the root user of the sys tenant (root@sys) or the administrator of each tenant. Specifically:

• In MySQL-compatible mode, the default administrator is the root user.
• In Oracle-compatible mode, the default administrator is the SYS user.

Syntax

ALTER SYSTEM DELETE delete_action [TENANT [=] tenant_name];

delete_action:
  BACKUPSET backup_set_id[,backup_set_id,...] 
| ARCHIVELOG_PIECE piece_id[,piece_id,...]

Parameters

Examples

• For the sys tenant

  • Clean up specified data backup sets.

    • The sys tenant deletes the data backup set with backup_set_id 3 of the mysql001 tenant.

      obclient(root@sys)[(none)]> ALTER SYSTEM DELETE BACKUPSET 3 TENANT = mysql001;
      

    • The sys tenant deletes three data backup sets with backup_set_id 1, 2, and 4 of the mysql001 tenant in a single command.

      obclient(root@sys)[(none)]> ALTER SYSTEM DELETE BACKUPSET 1,2,4 TENANT = mysql001;
      

  • Clean up specified log archive pieces.

    • The sys tenant deletes the log archive piece with piece_id 5 of the mysql001 tenant.

      obclient(root@sys)[(none)]> ALTER SYSTEM DELETE ARCHIVELOG_PIECE 5 TENANT = mysql001;
      

    • The sys tenant deletes four log archive pieces with piece_id 6, 7, 8, and 9 of the mysql001 tenant in a single command.

      obclient(root@sys)[(none)]> ALTER SYSTEM DELETE ARCHIVELOG_PIECE 6,7,8,9 TENANT = mysql001;
      

• For a user tenant

  • Clean up specified data backup sets.

    • The user tenant deletes the data backup set with backup_set_id 3.

      obclient> ALTER SYSTEM DELETE BACKUPSET 3;
      

    • The user tenant deletes four data backup sets with backup_set_id 1, 2, 4, and 5 in a single command.

      obclient> ALTER SYSTEM DELETE BACKUPSET 1,2,4;
      

  • Clean up specified log archive pieces.

    • The user tenant deletes the log archive piece with piece_id 5.

      obclient> ALTER SYSTEM DELETE ARCHIVELOG_PIECE 5;
      

    • The user tenant deletes four log archive pieces with piece_id 6, 7, 8, and 9 in a single command.

      obclient> ALTER SYSTEM DELETE ARCHIVELOG_PIECE 6,7,8,9;
      

References

• DELETE BACKUP ALL

• CANCEL DELETE BACKUP