backup_backup_dest_option

backup_backup_dest_option specifies parameters related to secondary backup.

Description

Parameters available in the backup_backup_dest_option configuration item are a subset of those in backup_dest_option. You cannot specify the backup_copies and log_archive_piece_switch_interval parameters in backup_backup_dest_option.

Example

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

In the command:

• log_archive_checkpoint_interval specifies the interval for performing secondary backup on log backups. If you do not specify this parameter, the value of the cluster-level configuration item log_archive_checkpoint_interval is used. If you do not specify either backup_backup_dest_option or log_archive_checkpoint_interval, the default value 120s is used. For more information about log_archive_checkpoint_interval, see log_archive_checkpoint_interval.

• recovery_window specifies the retention period of secondary backup data. If you do not specify this parameter, the value of the cluster-level configuration item backup_recovery_window is used by default. If you do not specify either backup_backup_dest_option or backup_recovery_window, the default value 0 is used, indicating that secondary backup data will never expire. For more information about backup_recovery_window, see backup_recovery_window.

• auto_delete_obsolete_backup specifies whether to automatically delete expired secondary backup data. If you do not specify this parameter, the value of the cluster-level configuration item auto_delete_expired_backup is used by default. If you do not specify either backup_backup_dest_option or auto_delete_expired_backup, the default value false is used, indicating that expired secondary backup data will not be automatically deleted. For more information about auto_delete_expired_backup, see auto_delete_expired_backup.