backup_backup_dest_option

backup_backup_dest_option specifies parameters related to second backup.

Description

Parameters available in backup_backup_dest_option 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=1h&recovery_window=14d&auto_delete_obsolete_backup=true';

Notes:

• The log_archive_checkpoint_interval parameter specifies the interval of second log backup operations when log splitting is not enabled. We recommend that you enable log splitting to start a secondary log backup.

• The recovery_window parameter specifies the time window for recovering second backup data. The system determines whether second backup data has expired based on the value of this parameter. For example, recovery_window='7d' indicates that data within the last 7 days is valid, and the second backup data irrelevant to the restore of this data is considered expired. For more information about the recovery_window parameter, see Automatically clear backup data.

• The auto_delete_obsolete_backup parameter specifies whether to automatically clear expired second backup data. For example, auto_delete_obsolete_backup=true specifies that expired second backup data is automatically cleared.

For more information about second backup parameters, see Preparations for secondary backup.