Google Groups Home
Help | Sign in
Message from discussion regarding the size of control file
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
yong...@yahoo.com  
View profile
 More options Aug 4 2005, 9:39 am
Newsgroups: comp.databases.oracle.server
From: yong...@yahoo.com
Date: 4 Aug 2005 06:39:02 -0700
Local: Thurs, Aug 4 2005 9:39 am
Subject: Re: regarding the size of control file

fitzjarr...@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


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2008 Google