Control_file_record_keep_time

RMAN and control_file_record_keep_time
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. Therefore it is recommended that the control_file_record_keep_time should set to a higher value than the RMAN retention policy.  Hence:

control_file_record_keep_time = retention period + level 0 backup interval + 1

For example, a level 0 backup once a week with retention policy of a recovery windows of 14 days would have a control_file_record_keep_time of 22 ( 14+7+1).

 

SQL> alter system set control_file_record_keep_time=30 scope=both;

System altered.

SQL> show parameter control;

NAME      TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time      integer 30

control_files      string +DATA/ACME/CONTROLFILE/current

.261.848598131, +FRA/ACME/CONT

ROLFILE/current.256.848598131

control_management_pack_access      string DIAGNOSTIC+TUNING

SQL>