alter database drop logfile group 4
*
ERROR at line 1:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '/u02/flash_recovery_area/AUX11G/onlinelog/o1_mf_4_83kw72wh_.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Resolution:
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 4;
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 4;
Database altered.