Re: ORA-01185: logfile group number 6 is invalid

Re: ORA-01185: logfile group number 6 is invalid

 

  

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] subscribe: send a blank email to oracledba-[Email Address Removed] 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 LazyDBA home page