Hi Tarek

Each group has only one log file and each logfile size
is 5M. Still i'm getting the error.

Please ...

Thanks
Sami

--- Tarek Ezzat <te.[Email Address Removed] wrote:
> The logfiles in alla the groups should have the same
> number and the same size
>
> >Dear All DBAs,
> >
> >I'm getting ORA-01185: logfile group number 6 is
> >invalid
> >
> >Could some one please explain me the reason?
> >
> >Not able to add new logfile group. My current DB
> has 3
> >redolog groups and would like to add another 3
> groups.
> >group number 4 and 5 added successfully but alter
> >database add logfile group 6
> >'D:\Oracle9i\oradata\Sami\Redo30.log' size 5M got
> >failed.
> >
> >
> > SQL> alter database add logfile group 5
> >'D:\Oracle9i\oradata\Sami\Redo20.log' size 5M;
> >
> > Database altered.
> >
> > SQL> alter database add logfile group 6
> >'D:\Oracle9i\oradata\Sami\Redo30.log' size 5M;
> > alter database add logfile group 6
> >'D:\Oracle9i\oradata\Sami\Redo30.log' size 5M
> > *
> > ERROR at line 1:
> >ORA-01185: logfile group number 6 is invalid
> >
> >
> >__________________________________________________
> >Do you Yahoo!?
> >Yahoo! Platinum - Watch CBS' NCAA March Madness,
> live on your desktop!
> >http://platinum.yahoo.com
> >
> >--------
> >Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> >To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] >To subscribe: send a blank email to
> oracledba-[Email Address Removed] >Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> >Tell yer mates about http://www.farAwayJobs.com
> >By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
>
>_____________________________________________________________________
> >GRAND JEU SMS : Pour gagner un NOKIA 7650, envoyez
> le mot IF au 61321
> >(prix d'un SMS + 0.35 euro). Un SMS vous dira si
> vous avez gagné.
> >Règlement : http://www.ifrance.com/_reloc/sign.sms
>
>
>
_____________________________________________________________________
> Envie de discuter en "live" avec vos amis ?
> Télécharger MSN Messenger
> http://www.ifrance.com/_reloc/m la 1ère messagerie
> instantanée de France
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Oracle LazyDBA home page