Automatically clear secondary backup data

You can automatically clear secondary backup data as needed.

Notes

• Only data stored in the backup destination specified by backup_backup_dest can be automatically cleared. If the destination of a secondary backup has been changed, it must be manually cleared upon expiration.

• Automatic data clearing will retain at least one valid secondary backup copy. If an expired backup is the only valid copy, it will not be automatically cleared.

Enable automatic clearing

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

2. Run the following command to set the expiration time and clearing policy of backup data:

   The following example enables automatic clearing of data older than fourteen days.

   obclient> ALTER SYSTEM SET backup_backup_dest_option='recovery_window=14d&auto_delete_obsolete_backup=true';
   

   In the command:

   • recovery_window specifies the retention period of secondary backup data.

     If you do not specify this parameter in the backup_backup_dest_option configuration item, the value of the cluster-level configuration item backup_recovery_window is used by default. If you do not specify either backup_dest_option or backup_recovery_window, the default value 0 is used, indicating that secondary backup data will never expire. We recommend that you use backup_backup_dest_option to specify the retention period of secondary backup data.

     When the secondary backup expires, the system automatically clears it based on preset rules.

   • auto_delete_obsolete_backup specifies whether to automatically delete expired backup data.

     If you do not specify this parameter in the backup_backup_dest_option configuration item, the value of the cluster-level configuration item auto_delete_expired_backup is used by default. If you do not specify either backup_dest_option or auto_delete_expired_backup, the default value false is used, indicating that expired backup data will not be automatically deleted. In this case, auto_delete_obsolete_backup must be set to true. We recommend that you use backup_backup_dest_option to specify whether to automatically clear expired backup data.

   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).