Secondary backup (tenant level)

The current version of OceanBase Database supports performing secondary backup at the tenant level.

Perform secondary backup on log backups

To perform secondary backup at the tenant level, you must run the following command to specify the tenant to be backed up and the secondary backup destination:

obclient> ALTER SYSTEM BACKUP BACKUPPIECE [= N] TENANT = tenant_name backup_backup_dest = [uri];

In the command:

• N indicates the backup_set_id to be included in the secondary backup.

• tenant_name indicates the name of the tenant.

• [uri] indicates the destination of the secondary backup.

Typically, only backup pieces in the FROZEN state are included in secondary backup. To include backup pieces in the ACTIVE state, you can run the following command to specify the WITH ACTIVE modifier:

obclient> ALTER SYSTEM BACKUP BACKUPPIECE ALL WITH ACTIVE TENANT = tenant_name backup_backup_dest = [uri];

Perform secondary backup on data backups

The following command performs secondary backup on data backups:

obclient> ALTER SYSTEM BACKUP BACKUPSET [= N] TENANT = tenant_name backup_backup_dest = [uri];

In the command:

• N indicates the backup set to be included in the secondary backup.

• tenant_name indicates the name of the tenant.

• [uri] indicates the destination of the secondary backup.