ORA-00313: drop standby logfile

from https://sites.google.com/site/djeday84/data-guard/ora-00313-drop-standby-logfile

SQL> alter database drop standby logfile group 12;
alter database drop standby logfile group 12
*
ERROR at line 1:
ORA-00313: open failed for members of log group 12 of thread 1
ORA-00312: online log 12 thread 1: ‘/u02/data/SBLPROD/stb_redo02.log’
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

select lf.group# as lgroup,thread#,lf.member,L.SEQUENCE#,l.bytes/1024/1024 as MB,l.status from v$logfile lf left join v$log l on l.group#=lf.group# order by 1,2
/

LGROUP    THREAD# MEMBER                                    SEQUENCE#         MB STATUS

---

     1          1 /u03/data/SBLUTF/redo01.log                       1        500 CURRENT
     2          1 /u03/data/SBLUTF/redo02.log                       0        500 UNUSED
     3          1 /u03/data/SBLUTF/redo03.log                       0        500 UNUSED
    12            /u02/data/SBLPROD/stb_redo02.log

SQL> alter database clear unarchived logfile group 12;
alter database clear unarchived logfile group 12
*
ERROR at line 1:
ORA-00344: unable to re-create online log ‘/u02/data/SBLPROD/stb_redo02.log’
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 1

SQL> alter database drop standby logfile group 12;

Database altered.

SQL> select lf.group# as lgroup,thread#,lf.member,L.SEQUENCE#,l.bytes/1024/1024 as MB,l.status from v$logfile lf left join v$log l on l.group#=lf.group# order by 1,2
/
2 3
LGROUP THREAD# MEMBER SEQUENCE# MB STATUS

---

     1          1 /u03/data/SBLUTF/redo01.log                       1        500 CURRENT
     2          1 /u03/data/SBLUTF/redo02.log                       0        500 UNUSED
     3          1 /u03/data/SBLUTF/redo03.log                       0        500 UNUSED

ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
alter database open resetlogs