Re: maxlogfiles

Question:
the statement is saying you want 32 members in each redo log group. Do you really want that? Redo log groups (and in your statement you have 3 groups with one member each) mainly consist for mirroring. Two members should usually be sufficient.
Probably you have exceeded the upper end of the allowable range (I don't know what it is either).

Hth,

--
Sybrand Bakker, Oracle DBA
<tazmon3d_at_my-deja.com> wrote in message news:7r8jsg$h6t$1_at_nnrp1.deja.com...


> I'm sure this is a rookie question but here it is... I am getting the

> following error while trying to create a database under Oracle 8:

>

> SVRMGR> create database ifas

>      2>         maxlogfiles 32

>      3>         maxlogmembers 32

>      4>         maxdatafiles 32

>      5> logfile

>      6>         '/data/oradata/ifas/redo_01.log' size 5M,

>      7>         '/data /oradata/ifas/redo_02.log' size 5M,

>      8>         '/data /oradata/ifas/redo_03.log' size 5M

>      9> datafile

>     10>         '/data /oradata/ifas/system_01.dbf' size 100M;

>         maxlogmembers 32

>                *

> ORA-02249: missing or invalid value for MAXLOGMEMBERS

>

>

> Where is MAXLOGMEMBERS set? I've looked through the doc & all I'm

> finding is a reference that says this is OS dependant if you take the

> defaults. I'm not taking default values in this case but this is a

> little confusing to me.

>

> Thanks

>

>

> Sent via Deja.com http://www.deja.com/

> Share what you know. Learn what you don't.