3 Replies Latest reply: Mar 28, 2013 9:18 AM by 995200 RSS

    Drop log group of non existing thread

    891445
      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