Re: Archive log files reaches maxloghistory

You will find that the CONTROL_FILE_RECORD_KEEP_TIME is more of a driver than MAXLOGHISTORY. For instance, C_F_R_K_T defaults to 7 days. Let's assume that you have MAXLOGHISTORY set to 1,000. What happens if you generate more than 1,000 logs in those 7 days? The control file will automatically expand and then the value for MAXLOGHISTORY will be increased. Eventually, the 7th day has been reached and the records will be overwritten in the control file. It was a couple of years ago that I did some experiments and posted the results to this very newsgroup.

HTH,
Brian

On Friday 24 October 2003 18:42, Peter thoughtfully contributed:

> What happens if the number of archive log files reaches the number
> equal to MAXLOGHISTORY? The control does not have enough space to hold
> information of any additional archive log files. Is it now safe to
> delete some of the older archive log fles.
>
> Thanks
Received on Sat Oct 25 2003 - 12:13:11 CDT