Relation between RMAN retention period and control_file_record_keep_time

In this Document
Purpose
Scope and Application
Relation between RMAN retention period and control_file_record_keep_time

Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.0 to 10.2.0.1 - Release: 8.1.7 to 10.2
Information in this document applies to any platform.
Purpose

Guideline to set CONTROL_FILE_RECORD_KEEP_TIME in relation to the RETENTION POLICY
Scope and Application
All DBA's using RMAN as Backup & Recovery tool
Relation between RMAN retention period and control_file_record_keep_time

RMAN backup keeps the backup metadata information in the reusable section of the controlfile. Its depends on the parameter CONTROL_FILE_RECORD_KEEP_TIME. CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and there is not enough space then it will delete the oldest record, which are aged enough.

Backup retention policy is the rule to set regarding which backups must be retained (whether on disk or other backup media) to meet the recovery and other requirements.

If the CONTROL_FILE_RECORD_KEEP_TIME is less than the retention policy then it may overwrite reusable records prior to obsoleting them in the RMAN metadata. Therfor it is recommended that the CONTROL_FILE_RECORD_KEEP_TIME should set to a higher value than the retention policy.

Formula

CONTROL_FILE_RECORD_KEEP_TIME = retention period + level 0 backup interval + 1

For e.g.

e.q. level 0 backup once a week with retention policy of a recovery windows of 14 days then in this case the CONTROL_FILE_RECORD_KEEP_TIME should be 14+7+1=22

Relation between RMAN retention period and control_file_record_keep_time [ID 397269.1]

No comments:

Post a Comment