Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Error in Logfile: ORA-00357: too many members specified for log file, the maximum is 2
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
![]() |
![]() |