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 LazyDBA home page