Re: regarding the size of control file

fitzjarrell_at_cox.net wrote:
> maxlogfiles: the maximum number of redo log files which can ever be
> created for a database.
>
> maxlogmembers: the maximum number of identical copies of a redo log
> allowed. The default and maximum values are operating system
> dependent.
>
> maxloghistory: this is only valid in ARCHIVELOG mode for Real
> Application Clusters, as it governs the mazimum number of archived redo
> log groups to use for recovery in a RAC configuration. Outside of RAC
> it has no effect on controlfile size.

In spite of the names, maxlogfiles is the limit of log file groups, not log files, and maxlogmembers is the limit of logfile members per group, not for the entire database. Even though all documentation including 8i SQL Reference says so, maxloghistory is for non-RAC or OPS as well, as implied by Note:237413.1 and Note:1060139.6. (But the two notes give an impression that maxloghistory sets the limit for logfiles or logfile members, instead of logfile groups as documentation clearly says.)

Yong Huang Received on Thu Aug 04 2005 - 08:39:02 CDT