Re: 9. What effect does setting Control_File_Record_Keep_Time to 0 have?
Originally posted by valexena
9.What effect does setting Control_File_Record_Keep_Time to 0 have?
Here is the explanation of this param
The CONTROL_FILE_RECORD_KEEP_TIME parameter specifies the number of days RMAN information is stored in the control file before being overwritten. A low value results in information being overwritten more frequently, thus minimizing control file growth.
If a recovery catalog is used, a lower value should be chosen. The
default is 7 days.
Note: When you use a recovery catalog, make sure that resynching is performed more frequently than overwrites to the control file.
For example, if set to 1, Recovery Manager information is kept for a day. If a recovery catalog is used, make sure resynching is performed at least once per day.