rec_his_retentn - Recovery history retention period configuration parameter
This parameter specifies the number of days that historical information on backups are retained.
- Configuration type
- Database
- Parameter type
- Configurable online
- Propagation class
- Transaction boundary
- Default [range]
- 90 [-1; 0 - 30 000]
- Unit of measure
- Days
If the recovery history file is not needed to keep track of backups, restores, and loads, this parameter can be set to a small number.
If rec_his_retentn is set to -1 and auto_del_rec_obj is set to OFF, the number of entries indicating full database backups, and any table space backups that are associated with the database backup, corresponds with the value specified by the num_db_backups database configuration parameter. Other entries in the recovery history file can only be pruned by explicitly using the available commands or APIs. If rec_his_retentn is set to -1 and auto_del_rec_obj is set to ON, the history file is not automatically pruned and no recovery objects are deleted.
If rec_his_retentn is set to 0 and auto_del_rec_obj is set to OFF, all entries in the history file, except the last full backup, are pruned. If auto_del_rec_obj is set to ON, automated history file pruning and recovery object deletion are carried out based on the timestamp of the backup selected by the num_db_backups database configuration parameter.
No matter how small the retention period, the most recent full database backup plus its restore set is always kept, unless you use the PRUNE command with the FORCE option.
If both the num_db_backups and rec_his_retentn configuration parameters are set, backups are not removed unless both the num_db_backups and rec_his_retentn conditions are satisfied.