ORA-00392: ORA-00312: alter database open resetlogs;

ORA-00392: ORA-00312: alter database open resetlogs;

alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1:

=======================================================================

SQL> startup mount
ORACLE instance started.

Total System Global Area 2588999680 bytes
Fixed Size                  2231072 bytes
Variable Size            2466252000 bytes
Database Buffers          100663296 bytes
Redo Buffers               19853312 bytes
Database mounted.


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '/recovery_area/AVP_ACF/onlinelog/o1_mf_1_9xlbmrml_.log'

SQL> select * from v$log;  

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
         1          1     105671  209715200        512          1 YES CLEARING_CURRENT    3218588416 13-NOV-14   3218555801 13-NOV-14
         3          1     105671  209715200        512          1 YES CLEARING            3218588416 13-NOV-14   3218588416 13-NOV-14
         2          1     105670  209715200        512          1 YES CLEARING            3218568602 13-NOV-14   3218568602 13-NOV-14

---
SQL> column member format a55
SQL> /

    GROUP# STATUS  TYPE    MEMBER                                                  IS_
---------- ------- ------- ------------------------------------------------------- ---
         3         ONLINE  /recovery_area/AVP_ACF/onlinelog/o1_mf_3_9xlbmvxw_.log  YES
         2         ONLINE  /recovery_area/AVP_ACF/onlinelog/o1_mf_2_9xlbmt7w_.log  YES
         1         ONLINE  /recovery_area/AVP_ACF/onlinelog/o1_mf_1_b8fxdlww_.log  YES
         4         STANDBY /recovery_area/AVP_ACF/onlinelog/o1_mf_4_9xlbmxj1_.log  YES
         5         STANDBY /recovery_area/AVP_ACF/onlinelog/o1_mf_5_9xlbmz1r_.log  YES
         6         STANDBY /recovery_area/AVP_ACF/onlinelog/o1_mf_6_9xlbn1fy_.log  YES
         7         STANDBY /recovery_area/AVP_ACF/onlinelog/o1_mf_7_9xlbn30o_.log  YES

7 rows selected.


SQL> alter database clear logfile '/recovery_area/AVP_ACF/onlinelog/o1_mf_1_9xlbmrml_.log';
Database altered.

SQL> alter database clear logfile '/recovery_area/AVP_ACF/onlinelog/o1_mf_2_9xlbmt7w_.log';
Database altered.

SQL> alter database clear logfile '/recovery_area/AVP_ACF/onlinelog/o1_mf_3_9xlbmvxw_.log';
Database altered.

SQL> select group#, status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CURRENT
         3 UNUSED
         2 UNUSED


SQL> alter database open resetlogs;
Database altered.