ORA-1623 on UNUSED log file (with wrong instance name in error)??

Apr 24, 2017 6:54PM

Hi,

I am trying to drop a log group from a restored database, and its giving me ora-1623

GROUP# STATUS TYPE MEMBER IS_

---------- ------- ------- ------------------------------------------------------------ ---

20 ONLINE +DATA02/sid1/onlinelog/group_20.278.941278579 NO

21 ONLINE +DATA02/sid1/onlinelog/group_21.279.941278581 NO

4 ONLINE +LOG1/sid1/onlinelog/redo4.log NO

.....

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------

......

6 1 9 1073741824 512 1 YES INACTIVE 1.1268E+13 24-APR-17 1.1268E+13 24-APR-17

20 2 0 1073741824 512 1 YES UNUSED 0 0

21 2 0 1073741824 512 1 YES UNUSED 0 0

ALTER DATABASE DROP LOGFILE GROUP 20

*

ERROR at line 1:

ORA-01623: log 20 is current log for instance UNNAMED_INSTANCE_2 (thread 2) - cannot drop

Database Administration (MOSC)