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
logfilelfleftjoinv
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
logfilelfleftjoinv
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