Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop log group of non existing thread

Vinay KMar 28 2013 — edited Mar 28 2013

How to drop an non-existing thread log group.
My database doesn't have thread 3; this has been added during cloning from 3 node to 2 node RAC.

alter database drop logfile group 10
*
ERROR at line 1:
ORA-01623: log 10 is current log for instance UNNAMED_INSTANCE_3 (thread 3) - cannot drop
ORA-00312: online log 10 thread 3: '+DATA/devdb/onlinelog/group_10.560.811225745'
ORA-00312: online log 10 thread 3: '+FLASHBACK/devdb/onlinelog/group_10.360.811225745'

 GROUP#    THREAD#     seq#    STATUS
 10                    3               1         ACTIVE              
 11                    3               0         UNUSED

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2013

Added on Mar 28 2013

#general-database-discussions

3 comments

490 views