Re: archivelog or not

Sorry, it does not. The control_file_record_keep_time parameter defines how long a reusable record is to be maintained in the controlfile before that 'slot' can be reused. Yes, this does apply to archivelog records in the controlfile, but it's not a count of how many times the archivelog information is kept, it determines how long each archivelog record is to be maintained in the controlfile. Increasing this parameter usually results in expanding the controlfile due to reusable records not being aged out as quickly prior to the addition of new reusable records, thus not leaving space for the subsequent entries.

David Fitzjarrell

srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0301082138.50abe7a_at_posting.google.com>...
> You cant define the number of archive generated, but you can define
> the limit as to the information about the archives generated in the
> control file.
> The control_file_record_keep_time parameter specifies for how many
> times the archive log information is maintained in the control file.
> You can see the current usage using V$CONTROLFILE_RECORD_SECTION
> regards
> Srivenu
Received on Thu Jan 09 2003 - 09:21:06 CST