Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive log files reaches maxloghistory
On Sat, 25 Oct 2003 12:13:11 -0500, Brian Peasland
<dba_at_remove_spam.peasland.com> wrote:
I original set the maxloghistory to 500 but now it has expanded to 900 within 7 days, thanks to CONTROL_FILE_RECORD_KEEP_TIME = 7 days Now I am considering resetting CONTROL_FILE_RECORD_KEEP_TIME to a smaller number.
Thanks
>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 Sun Nov 09 2003 - 18:59:49 CST