Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archive log files reaches maxloghistory

Re: Archive log files reaches maxloghistory

From: Peter <peter_at_nomorenewspamin.ca>
Date: Mon, 10 Nov 2003 00:59:49 GMT
Message-ID: <skotqvoanclaph59e2bae702eijnd7hfhr@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US