ORA-01623: log 3 is current log for instance i2 (thread 2) – cannot drop

SYS@upgc> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------------- ------------- ----------------- ------------ -----------------
 1 1 201 1073741824 512 1 NO
INACTIVE 3494533596 10-08-15 14:47:03 3495360737 10-08-15 17:17:13

2 1 202 1073741824 512 1 NO
CURRENT 3495360737 10-08-15 17:17:13 2.8147E+14

3 2 0 1073741824 512 1 YES
UNUSED 0 0

 GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------------- ------------- ----------------- ------------ -----------------
 4 2 0 1073741824 512 1 YES
UNUSED 0 0

SYS@upgc> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance i2 (thread 2) - cannot drop
ORA-00312: online log 3 thread 2: '+REDO/upgc/onlinelog/group_3.318.886112727'

SYS@upgc> alter database disable thread 2;

Database altered.

SYS@upgc> alter database drop logfile group 3;

Database altered.

SYS@upgc> alter database drop logfile group 4;

Database altered.

Komentáře