Thursday, October 8, 2009

Oracle Bugs: Drop redo log group inside asm diskgroup

Symptons:


SQL> alter database drop logfile group 1;
alter database drop logfile group 1
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [],
[], []


SQL> alter database drop standby logfile group 13;
alter database drop standby logfile group 13
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kgeade_is_0], [], [], [], [], [],
[], []


Environment:

Linux (5.3) x86_64 + Oracle 10.2.0.4 64bit (with oracle clusterware/asm/db)

Workaround:

Indeed the redo log groups has been dropped, so these ora-600 errors can be ignored.