ORA-01624: Log 1 Needed For Crash Recovery Of Instance

Get redo log Group Status :

select l.group#, l.thread#,

f.member,

l.archived,

l.status,

(bytes/1024/1024) fsize

from

v$log l, v$logfile f

where f.group# = l.group#

order by 1,2

To change the status from ACTIVE to INACTIVE, switch logfile multiple times, till the status is INACTIVE.

SQL> alter system switch logfile;

SQL> @log_member

alter system switch logfile;

SQL> @log_member

Once the redo log group status is INACTIVE, drop it.

SQL> alter database drop logfile group 1;

Database altered.

Hope It Helps !