ANKUSH THAVALI03 Sep, 20230 Comments45 Secs ReadORA-01624: Log 1 Needed For Crash Recovery Of Instance ORA-01624: Log 1 Needed For Crash Recovery Of Instance Solution : 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 ! Oracle DBAShare: How To Run Expdp In Pluggable Database(PDB)ORA-15260: Permission Denied On ASM Disk Group