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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Error in Logfile: ORA-00357: too many members specified for log file, the maximum is 2

Re: Error in Logfile: ORA-00357: too many members specified for log file, the maximum is 2

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Fri, 11 Oct 2002 20:06:05 +0200
Message-ID: <ao74cl$eph$1@reader12.wxs.nl>


It means that the maximum number of members, or copies, for a REDO LOG FILE GROUP exceeded a certain maximum.
A maximum specified by the MAXLOGMEMBERS clause in the CREATE DATABASE command. If no MAXLOGMEMBERS parameter is specified for the CREATE DATABASE statement, Oracle uses an operating system default value (which in your case could to be 2) The only way to override this upper limit is to re-create the database (CREATE DATABASE) or the control file (CREATE CONTROLFILE).
I let you make that choice. Whatever sollution you take, read the instructions carefully.

"DaveK" <DaveK_at_the.NEt> wrote in message news:P1Bp9.104473$Fw2.3413998_at_twister.austin.rr.com...
> ORA-00357: too many members specified for log file, the maximum is 2
>
>
>
> I have found some info on using the CREATE CONTROLFILE but wanted to see if anyone could offer
some
> info or maybe a recommendation.
>
>
>
> Thanks
>
>
>
> DaveK
>
>
Received on Fri Oct 11 2002 - 13:06:05 CDT

Original text of this message

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