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

ANKUSH THAVALI
03 Sep, 2023
0 Comments
45 Secs Read

ORA-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 !