Re: Q:altering maxlogfiles

There is an init.ora parameter. Probably something like max_log_group_members. I don't know it off the top of my head but if you want I will try to look it up.

scott swords wrote:

> how can I alter this once the database has been created? I'm getting
> this error and I would like to add more logfile members to a specific
> group
>
> example:
> --------------------------------------------------------------------
> currently group1 /disk1/oradata/logfile1a.log
> group1 /disk2/oradata/logfile1b.log
>
> group2 /disk1/oradata/logfile2a.log
> group2 /disk2/oradata/logfile2b.log
> --------------------------------------------------------------------
> trying
> group1 /disk1/oradata/logfile1a.log
> group1 /disk2/oradata/logfile1b.log
> group1 /disk3/oradata/logfile1c.log
>
> group2 /disk1/oradata/logfile2a.log
> group2 /disk2/oradata/logfile2b.log
> group2 /disk3/oradata/logfile2c.log
>
> group3 /disk1/oradata/logfile3a.log
> group3 /disk2/oradata/logfile3b.log
> group3 /disk3/oradata/logfile3c.log
> --------------------------------------------------------------------
> here's my error:
> ORA-00357: too many members specified for log file, the maximum is 2
Received on Thu Mar 29 2001 - 11:24:21 CST