Re: Q:altering maxlogfiles

"David Busby" <dbusby3_at_slb.com> wrote in message news:3AC36FC5.87BDB108_at_slb.com...
> 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
>

He needs to recreate the controlfile, there is *NO* init.ora parameter.

So

alter database backup controlfile to trace find the the trace file in the user_dump_dest directory, edit it if necessary and run it.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 29 2001 - 12:13:42 CST